Interval set analysis

jaymerry — Wed, 20 Jul 2011 12:55:47 GMT

Hello,

Do you know if it's possible to make an interval with a set analysis ?

I'm trying to find the values contains between the last two char of CATEGORY => 11 and the last two char of CATEGORY <=16 (I have the function right() ) :

example of CATEGORY's data :

99-12

98-14

97-09

I have tried :

=sum({<%CATEGORY={"=RIGHT(%CATEGORY,2)>=11,RIGHT(%CATEGORY,2)<=16"}>}[Qty])

=sum({<%CATEGORY={"=RIGHT(%CATEGORY,2)>=11"},%CATEGORY={"=RIGHT(%CATEGORY,2)<=16"}>}[Qty])

But it doesn't work..

Have you any idea ?

Thanks for your help,

Best regards,

Jaymerry

Interval set analysis

danielrozental — Thu, 21 Jul 2011 15:57:49 GMT

here's an idea for you, create a fild in the script with the right(%CATEGORY,2) and do the setanalysis on that.

topic Interval set analysis in QlikView

Interval set analysis

Interval set analysis