Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Total whitout one column

Hello Qliks,

Currently, my applications show Total of all columns, like below:

1.png

Are exist way to exclude one column from that total? Of course, that column should be still present in the table. Column, which I want to exclude is:

Dim Year-Month = 2017-May    &&    Dim Plan Code = FCT

1.png

Regards

Jacek.

11 Replies
sunny_talwar

My bad, you need this

If(SecondaryDimensionality() = 0,

Sum({1}Aggr(If(Above($(vRevenue)) > 0 and Above(Only({1<[Plan Code] = {'ACT', 'FCT'}>}[Plan Code])) = 'ACT', 0, $(vRevenue)), [Year-Month], [Plan Code])),

$(vRevenue))

Capture.PNG

Anonymous
Not applicable
Author

Thank you, Sunny. One more time you proofed that impossible is possible.I wish you a good day.

Regards

Jacek.