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 make QS display only 1-30 column only and hide the rest of column ? when i select Aging = 1-30.

Hi All

I have a pivot table , when i select Aging period 1-30 ,

it does able to display the correct 1-30 aging amount , my question is when i do this in QV , it only display 1-30 column.

But in QS it display all column info include 1-30 . 31-60 etc.

How to make QS display only 1-30 column only and hide the rest of column ? when i select Aging = 1-30.

Paul Yeo

1 Solution

Accepted Solutions
Vasiliy_Beshentsev
Creator III
Creator III

OR

if you want display only 1-30 column then do this:


34.png

View solution in original post

4 Replies
paulyeo11
Master
Master
Author

Hi All

Enclosed my QVF

Vasiliy_Beshentsev
Creator III
Creator III

2.png3.png

Vasiliy_Beshentsev
Creator III
Creator III

OR

if you want display only 1-30 column then do this:


34.png

paulyeo11
Master
Master
Author

Hi Vasiliy

Thank you very much,

Now i understand why.

So i just create a new field , which is ar_aging_class , which break the aging day in to :-

1-30

31-60 and so on.

and i just using ar_aging_class and it work fine now.

Paul Yeo