Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
jaceknoden
Creator
Creator

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.

1 Solution

Accepted Solutions
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

View solution in original post

11 Replies
prat1507
Specialist
Specialist

See Attached example. Refer to Conditional show/hide sub totals in Pivot table

Regards

Pratyush

jaceknoden
Creator
Creator
Author

Thank you Pratyush, but is not what I  look. That solution just hide/show total and I want to see all time total, but minus one column.



Regards

Jacek.

sunny_talwar

Would you be able to share a sample where you are trying to do this? Also, you want the total to not include Fcst where Actual and Fcst are both available?

jaceknoden
Creator
Creator
Author

Hello Sunny,

Yes, I want that total, which you described. Unfortunately, I can't attach that application, because contain many important data for  firm. I tried to eeduce data by Preparing examples for Upload - Reduction and Data Scrambling but without success.

Regards

Jacek.

sunny_talwar

What was the issue you ran into while reducing and scrambling your data?

jaceknoden
Creator
Creator
Author

Hello Sunny, I had yesterday problem with connection. I prepare special app just with the problem.

Frank_Hartmann
Master II
Master II

Please reupload!

Access denied to this QV document!

jaceknoden
Creator
Creator
Author

Yes, I forgot about section access. New upload.

sunny_talwar

May be this

If(Dimensionality() = 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