topic Re: Result of expression between range in QlikView

Result of expression between range

Thu, 09 Aug 2012 10:44:46 GMT

I have a table without relation or key with associative model, this table has the ranges (minimum value,maximum value and qualification) and the rating on the other hand I have an expression and result of this, should be classed with this table ranges.

This is the rante island table

MinVal	MaxVal	Qualification
0	10	1
11	20	2
21	30	3
31	100	4

And this is the pivot table desired

DIM	Sum(Value)	Qualification
A	8	1
B	15	2
C	23	3
D	50	4

How should i do this?

Thanks...

Re: Result of expression between range

swuehl — Thu, 09 Aug 2012 10:53:45 GMT

Try maybe

=aggr(if( Sum(Value) <=MaxVal and Sum(Value) >= MinVal,Qualification),Qualification,DIM)

Re: Result of expression between range

Thu, 09 Aug 2012 12:32:09 GMT

I tried with this option and works fine Thanks !!