Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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
Luminary Alumni
Luminary Alumni

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