I am trying to group by location and month year in this script.
,ApplyMap( 'LOCNameMap', LOC_ID, '*Unknown' ) as Location;
date(MonthStart(QualityDate),'MMM YYYY') as MonthYear,
ApplyMap( 'LOCIDMap', DEPARTMENT_ID, '*Unknown' ) as LOC_ID
I know in qlikview group by you have to list all of the fields you are not aggregating, and none of these fields have anything to aggregate,
I tried to inner join the above table to
resident original table.
Is this the best way to do this?