#1 KPI if condition not working

[hd1]

Hi,

I am facing a problem with Qliksense #1 KPI. 

In the measure i have placed the following code:

 IF (ID = 1 , (current_Value/ predicted_Value)*100, 'condition not met' )

I get condition not met in the KPI.

Can any one help? 

I have attached a sample of the data

Many thanks

[ramasaisaksoft]

Hi Dude,

As per your condition when ever you select "ID" in List box as 1 then only your KPI will show (50/235)*100  other wise it will show  "condition not met" ( I mean if you are not selected any value in ID field and selected other than 1)

so check like this create a List box /Filter "ID" select "1" from there then your #KPI will show the expected value.

[hd1]

this didnt work.. What i want is to view a average KPI for 'Mugs & Drinkware' .

so i can display  (50/235)*100 result for when the ID = 1 

[hd1 · Accepted solution]

Solved it! 

for anyone who wants reference here is the query i used : 

Sum({$< ID ={"1"}>}current_Value/ predicted_Value) *100