Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

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_beshent
Contributor III

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

OR

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


34.png

4 Replies
paulyeo11
Valued Contributor II

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

Hi All

Enclosed my QVF

vasiliy_beshent
Contributor III

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

2.png3.png

vasiliy_beshent
Contributor III

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

OR

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


34.png

paulyeo11
Valued Contributor II

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

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

Community Browser