Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
varunreddy
Contributor III

How to add the subtotal for the table

Hi All,

I have 2 fields Code and Indicator and I want to display the total for every value of Code. I want to do it in a table and wanted to do it using Front End. Can some one please help me?

Input:

CodeIndicatorNumber
A 41992
AY1311
B 2966
BY34
S 3791
SY17

 

Desired O/P:

CodeIndicatorNumber
A 41992
AY1311
Total 43303
B 2966
BY34
Total 3000
S 3791
SY17
Total 3808

 

Thanks,

Varun

Labels (2)
1 Solution

Accepted Solutions
maxronny
New Contributor III

Re: How to add the subtotal for the table

i send you again the zipped qvf file 

7 Replies
Highlighted
maxronny
New Contributor III

Re: How to add the subtotal for the table

Hi Varun,

please find the solution in the attached file.

clipboard_image_0.png

varunreddy
Contributor III

Re: How to add the subtotal for the table

Hi Max,

Thanks for the quick response. But I am trying to achieve this in QlikSense using the table.

 

Cheers,

Varun

 

Partner
Partner

Re: How to add the subtotal for the table

Why not use a pivot table?
maxronny
New Contributor III

Re: How to add the subtotal for the table

qliksense is the same as qlikview.

you can use the pivot table with subtotal

maxronny
New Contributor III

Re: How to add the subtotal for the table

here you are the qliksense file with the solution.

with regards,

Massimo

varunreddy
Contributor III

Re: How to add the subtotal for the table

Hi Massimo,

Can you please reattach the file. I am unable to download the qvf?

maxronny
New Contributor III

Re: How to add the subtotal for the table

i send you again the zipped qvf file