Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
paulyeo11
Valued Contributor II

How to compute aging by every 30days ?

Hi All

I have Table

Dimension = Aging by day

Expression = Total Amount.

May i know how to use CLASS to break the Aging in below format ?

1-30

31-60

61-90

91-120

121-150

151-180

>181

Hope some one can advise me.

Paul

1 Solution

Accepted Solutions

Re: How to compute aging by every 30days ?

Not sure, but does this seem right?

Capture.PNG

6 Replies
paulyeo11
Valued Contributor II

Re: How to compute aging by every 30days ?

My QVW FILE

Re: How to compute aging by every 30days ?

Not sure, but does this seem right?

Capture.PNG

paulyeo11
Valued Contributor II

Re: How to compute aging by every 30days ?

Hi Sunny

thank you very much for your help in make my chart look nice, and also help me modify the expression using match and pick. appreciated very much.

ap chart.png

Re: How to compute aging by every 30days ?

Do the numbers look right? Doesn't match what you have in the other chart.

paulyeo11
Valued Contributor II

Re: How to compute aging by every 30days ?

yes , of course. thank

Re: How to compute aging by every 30days ?

Great

Community Browser