topic dynamic interval match in QlikView

dynamic interval match

amien — Sun, 16 Aug 2009 03:53:40 GMT

// INTERVALS

Intervals:
LOAD * INLINE [
StartValue, EndValue, Buckets
0, 100, 1
100,200, 2
300,99999, 3
];

// INTERVALMATCH_TABLE

intervalmatch (Frame)
Load StartValue,EndValue resident Intervals;

This is a standard intervalmatch example

the problem is that i want to intervalmatch an AVG value based on the current selection. i dont know if this is possible. AVG is calculated every time a different selection is made .. so i cant do this during loading.

my question: is realtime interval match possible .. and how

dynamic interval match

Oleg_Troyansky — Mon, 17 Aug 2009 10:01:46 GMT

well, since INTERVALMATCH is a function that belongs to the script, it's not available in the run-time (or "real-time" as you say). I think you can reach a desired result using Set Analysis - if you look at the last example in the "Set Analysis" article, it shows a set analysis expression based on a result of an aggregation.

cheers,

Oleg

dynamic interval match

johnw — Tue, 18 Aug 2009 02:58:19 GMT

Something like this?

=if(avg(...)<=100,dual( '0-100',100)
,if(avg(...)<=200,dual('101-200',200)
,if(avg(...)<=300,dual('201-300',300)
,dual('301+' ,999))))

dynamic interval match

amien — Tue, 18 Aug 2009 14:23:41 GMT

John,

Thanks again for your reply .. that nice .. but how do i connect that to a listbox where i can select the values:0-100, 101-200 etc?

dynamic interval match

johnw — Wed, 19 Aug 2009 00:58:35 GMT

Try using the same expression in a list box. Create a new list box. On the general tab, under Field, select <Expression>. Enter the expression. I think it will work, and dynamically adjust based on your other selections, but I could be wrong. Worth a try.