Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. 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
Highlighted
maxronny
New Contributor III

Re: How to add the subtotal for the table

i send you again the zipped qvf file 

View solution in original post

7 Replies
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?

Highlighted
maxronny
New Contributor III

Re: How to add the subtotal for the table

i send you again the zipped qvf file 

View solution in original post