Multi selection

[#1]

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

[sujeetsingh]

Try nested IF statement

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

[datanibbler]

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

[#4]

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

Pls see the attachment

[#5]

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