Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
rajarshi_guin
Not applicable

Totals at different levels

Hi All,

In my dashboard I have data in the format in a table.

     

FirmAgent IDCases ClosedCases CreatedIn-Progress Cases
A11000
A220100
B30100
B420200

The columns Firm and Agent ID are dimensions while others are measures.

Now I need to show the totals based on both the firm level as well as the total for the whole table. So, the output should appear as below.

    

FirmAgent IDCases ClosedCases CreatedIn-Progress Cases
A11000
A220100
Totals30100
B30100
B420200
Totals20300
Totals 50400

So, the first Totals in row no. 3 will show the total for firm A, i.e., sum of values for Agent Id 1 and 2. The Totals in row no. 6 will show the total for firm B, i.e., sum of values for Agent Id 3 and 4. And the Totals in row no. 7 will show the sum of values for firm A and B.


Can anyone please tell me how to implement this in qlik sense.


Thanks,

Rajarshi Guin

3 Replies
sunny_talwar
Not applicable

Re: Totals at different levels

Create a pivot table and enable subtotals for Agent ID field

vkish16161
Not applicable

Re: Totals at different levels

Sunny's solution is better,

But if you're okay with the table looking slightly different, you can try:

Create 1 measure for Cases Closed and use:

Only(Aggr( Sum([Cases Closed]) , Firm ) )

// -------------- -------------- -------------- --------------

Create 1 more measure for Cases Created and use:

Only(Aggr( Sum([Cases Created]) , Firm ) )

devarasu07
Not applicable

Re: Totals at different levels

Hi

Just enable total on the Firm & Agent ID row dimension in a pivot table

Capture.JPG