I have a requirement where there are 3 dimensions and 8 measures to be shown in a table.
I have used a Qlik table to display the data. Here the Total is being shown on the top row i.e total for all the measures under the measure column.
But the Business wants to see 4 rows of total one below the other. These totals should be displayed before the data field starts.
|Header 1||Header 2|
Total East Rev
Total West Rev
Total South Rev
Total North Rev
I am not able to do this in normal Qlik table. But was wondering if this could be achieved by using a Vizlib table.
Any help would be highly appreciable.
maybe it's not far from what you want :
in dimension use : valueloop(1,2) , Region, Name
and in expression :
if( (valueloop(1,2)=2 and dimensionality()=3)
or (valueloop(1,2)=1 and dimensionality()=2),sum(revenue))
hide dimension valueloop(), and add subtotal for dimension name
look like this :