topic Re: If condtion in Set analysis KPI in QlikView

If condtion in Set analysis KPI

kunkumnaveen — Fri, 27 Mar 2020 11:38:18 GMT

Hello All,

i have to apply two filters in my set analysis and need to show the value in KPI,

1)NOD<15

2)Sum(M_Count)<10

In the below Straight table

Dimensions:

Stock,Model,Material,Vendor, Nod

Expression :

Sum(M_Count)

so i need to show count of distinct vendor whose NOD<15 and Sum(M_Count)<10,

So in KPi i need to count of vendors as :3

Kindly suggestion me how to write a expression with two filters in KPI

kunkumnaveen — Fri, 27 Mar 2020 12:46:31 GMT

I tried below exp in KPI

count({<NOD={"<20"},Stock={'Vendor'},M_Count={'=sum(M_Count)<10'}>}distinct total <Stock,model,Material>vendor)

But its not working.

kunkumnaveen — Fri, 27 Mar 2020 13:37:52 GMT

Any Suggestion on my above requirement plz

alex00321 — Mon, 30 Mar 2020 08:45:50 GMT

I'm not sure if you could use M_Count={'=sum(M_Count)<10'} in your expression. Maybe you could share sample data?

kunkumnaveen — Tue, 31 Mar 2020 11:35:05 GMT

I have sorted this by creating a Flag at scripting