Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
girishchhatani1
Contributor III
Contributor III

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))

View solution in original post