Expression question about "Executive Dashboard" demo.

[#1]

Hi,

For an assignment I have to analyze the "Executive Dashboard" demo from Qlikview.
Also I have to make a few new graphs, which is what my question is about.

I want to design a graph showing only the AR's (Accounts Receivables) that are 30+ days due.
How do I make such an expression?

I have attached 2 screenshots, the first one with the ARCurrent, AR1-30, AR30-60 and AR60+ is what I have now.
The other one is how I want it to be (I have selected AR30-60 and AR60+), but I want the graph to only show this all the time.

Thanks in advance.

[#2]

You could just hardcode the values into your expression.

Please paste the expression

[#3]

I have 2 dimensions:

Customer
ARAge

The customer dimension has "SUM([AROpen])" as expression.
The ARAge dimension has no expression (yet), and that's what my question is about, how do I let it only show the AR31-60 and AR60+ values??

[#4]

I dont understand - can you post your qlikview document?

[#5]

It's in the last sheet. The other sheets are from the demo itself.
(Sorry if some things are in Dutch)

[#6 · Accepted solution]

like this?

[#7]

Yes! Thank you!