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: 
paulyeo11
Master
Master

.How to hide 9 column and only display summary total ?

Hi All

I have add one more expression to my existing pivot table :-

If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=151'} >}total_ar  * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1)) > 0,

Sum(if(L5M='-1',sales)))

I only need to see the summary column. may i know how to hide those column in 1-30 , 31-60 , 61-90 ? as they are zero. So that i can reduce total 9 column.

Paul

3 Replies
paulyeo11
Master
Master
Author

my QVW

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

If you want to hide all columns for that Dimension, why not remove the dimension?

-Rob

paulyeo11
Master
Master
Author

Hi Rob

Thank you for your feedback.

For AR field i need to view the aging amount.

For sales i only want to view the summary.

If i hide the diamension , you are right i can view the sales summary but unable to view the AR aging.

Paul