Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Multi row total on top of a table in Qlik Sense

Hi All,

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.

Example

Header 1Header 2

Name

Revenue

Total East Rev

Total West Rev

Total South Rev

Total North Rev

1000$

2000$

3000$

4000$

Scholes500$
Beckham800$

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.

mahlermastevedark

2 Replies
Highlighted
Specialist II
Specialist II

Hi,

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 :

regards

Highlighted
Partner
Partner

Hi Amijit,

This could be achieved using the recently released vizlib pivot table, when you dynamic border control of cells.

Check it out at www.vizlib.com/pivot

Alternatively, with the Vizlib Table, you can use dynamic css styling, so you could modify the css attributes for the border on a cell level (with the vizlib table it comes a bullet bar chart example that does something similar btw)

Cheers,

David