matching Interval

[Frank_Hartmann]

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]

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]

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?