Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

If condtion in Set analysis KPI

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,

 

Untitled.png

 

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

 

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

1 Solution

Accepted Solutions
kunkumnaveen
Specialist
Specialist
Author

I have sorted this by creating a Flag at scripting

View solution in original post

4 Replies
kunkumnaveen
Specialist
Specialist
Author

 

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
Specialist
Specialist
Author

Any Suggestion on my above requirement plz

alex00321
Creator II
Creator II

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

kunkumnaveen
Specialist
Specialist
Author

I have sorted this by creating a Flag at scripting