Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

amijit_hazarika
New 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

Tags (2)
2 Replies
ogautier62
Valued Contributor II

Re: Multi row total on top of a table in Qlik Sense

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

anguila
Contributor

Re: Multi row total on top of a table in Qlik Sense

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