wiki:RemoveTotalRowInSurveyQueries

Removing Total Row in Survey Queries

Surveys are analyzed with SAS PROC SurveyMeans
hi_iq_func.exe does not provide a data_frame when PROC SurveyMeans is used

IBIS View provides <ADD_MISSING_QUERY_RESULT_RECORDS><ALL_FLAG/></ADD_MISSING_QUERY_RESULT_RECORDS> and <MISSING_QUERY_RESULT_RECORD_VALUE>n/a</MISSING_QUERY_RESULT_RECORD_VALUE> for providing missing rows in results

hi_iq_func has a f no_total true flag for use in .def and .cfg

The combination of all of these may still provide a total row when it is not needed.

One solution that has worked to remove the total row is to remove or comment out the
<VALUE>.<TITLE>Total</TITLE><NOT_SELECTABLE_FLAG/></VALUE> row in all dimension files that are used for cross variables

Last modified 23 months ago Last modified on 05/08/17 17:09:50