Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Issue while Calculation sub total in pivot chart

Hey Friends,

I am unable to calculate correct Subtotal for expression having one dimension called YearMonth.

  

YearMonthWI Revenue
2017041,748
2017051,948
2017061,985
2017072,177
2017081,872
2017091,783
2017101,829
2017111,721
2017121,824
2018011,837
2018021,667
2018031,832
Total            -

I tried using Dimensionaly() to get the total but still i m unable to derive the total nos.

Could you guys please help me on this.

Thanks & Regards,

Girish Chhatani@

1 Solution

Accepted Solutions
sunny_talwar

What is your expression here? Use Sum(Aggr(Expression, YearMonth))

View solution in original post

1 Reply
sunny_talwar

What is your expression here? Use Sum(Aggr(Expression, YearMonth))