How to add the subtotal for the table

[varunreddy]

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:

Code	Indicator	Number
A		41992
A	Y	1311
B		2966
B	Y	34
S		3791
S	Y	17

Desired O/P:

Code	Indicator	Number
A		41992
A	Y	1311
Total		43303
B		2966
B	Y	34
Total		3000
S		3791
S	Y	17
Total		3808

Thanks,

Varun

[maxronny]

Hi Varun,

please find the solution in the attached file.

[varunreddy]

Hi Max,

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

Cheers,

Varun

[dplr-rn]

Why not use a pivot table?

[maxronny]

qliksense is the same as qlikview.

you can use the pivot table with subtotal

[maxronny]

here you are the qliksense file with the solution.

with regards,

Massimo

[varunreddy]

Hi Massimo,

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

[maxronny · Accepted solution]

i send you again the zipped qvf file