topic Re: Multi selection in QlikView

Multi selection

Wed, 20 Nov 2013 11:25:05 GMT

Hi,

I have a table of Kpi's that each has different values, I need to filter the UnitCd who have different values in each kpi.

For example: I want to get all the UnitCD that have value for Kpi= SC120013 between 20 to 60 and

for Kpi = SC1200141 have a value of between 5 and 16
And for Kpi = SC120051 have equal value 3

Pls Help

Re: Multi selection

sujeetsingh — Wed, 20 Nov 2013 11:28:17 GMT

Try nested IF statement

=if(KPI>=20 and KPI<60,UNITCD,0)

Re: Multi selection

datanibbler — Wed, 20 Nov 2013 11:30:51 GMT

Hi ofra,

for just one KPI this is "relatively easy": You have to use IntervalMatch().

- Process your data in the script to have the correct values of that KPI for every UnitCD (say, that's a field
>>> KPIvalue <<<

- Load an Inline table with the intervals you want, using >>> IntervalMatch(KPIvalue) <<<

For several KPIs, you would have to use set analysis, specifying a lower_ bound and an upper_bound for both/ all of the KPIs in question and use a simple COUNT() as expression (y-axis) in your chart

=> You can, I guess, replace parts of your set_expression with fields/ variables that the user can select.

HTH

Best regards,

DataNibbler

Re: Re: Multi selection

Wed, 20 Nov 2013 11:34:44 GMT

I have all of the UnitCD that the value of their numerator for each Kpis is different.

Pls see the attachment

Re: Re: Multi selection

Wed, 20 Nov 2013 13:00:46 GMT

I have more than 200 Kpis how can i manage this with variables?