topic Re: matching Interval in QlikView

matching Interval

Frank_Hartmann — Tue, 16 Feb 2016 20:58:05 GMT

Hi QV Community,

I am missing to match an constructed (in script) interval for some datapoints!

i have attached a qwv and excel with detailed description of the probleme!

Any help is appreciated

swuehl — Tue, 16 Feb 2016 23:11:58 GMT

I can't see anything wrong with the classification, you are using

sum({<MonthDiff={'>=$(vZeitraum12Monate)<=$(vAktuellerMonat)'} >}Daten_Vorgang_Sonderauswertung)

in your table chart, but you are calculating the intervals statically in the script without the date range limitiation.

As soon as you remove the set expression, the intervals seem to match your sum.

Regarding the sort order of your intervals, just create the value '>5000' as dual value, like dual('>5000', 5001)

See attached qvw that demonstrates what I am trying to tell.

Frank_Hartmann — Wed, 17 Feb 2016 09:24:52 GMT

Hello Stefan,

thank you for answering!

The probleme in my example is, that i have to filter down the data to the last 12 month.

In your solution the sum(Daten_Vorgang_Sonderauswertung) for outlet "a1" = 1.

But this datapoint is for KW17-2014 and not within the range which i should apply.

Can you give me a hint how to setup the the interval dynamically in script in order to

filter down the data to the last 12 month and also be able to link the values correctly to the intervall?