Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to show chart w/o dimension?

Hi,

I have these ageing computation, computation is cannot be done thru script because the data should shown dynamically, so when I select dates, that di only time the calculation perform. See expression below:

This will display current data:

if(dOver <= 0, sum({$<Date = {"<=$(maxDate)"}, Year =, Month =, Day =>} [Total AR]), 0)

So would that information is possible to display amounts per Document No., without any set dimension?

Is AGGR useful for this.

2 Replies
erich_shiino
Honored Contributor

Re: How to show chart w/o dimension?

Hi, I'm not sure if I understood you correctly.

How do you want to present this information?

Does this expression calculates ageing per document? Do you want to summarize it and present a single value?

Maybe this can help:

Avg( aggr ( if(dOver <= 0, sum({$<Date = {"<=$(maxDate)"}, Year =, Month =, Day =>} [Total AR]), 0) , [DocumentID]) )

This will calculate the expression for each DocumentID ( you can replace this field) and then calculate the average of the results for all documents.

Hope this helps

Erich

Not applicable

Re: How to show chart w/o dimension?

Getting the sum per age,

say total sum of CURRENT

total sum of 30-60

total sum of 61-90

Like that.

Community Browser