Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Solved it!
for anyone who wants reference here is the query i used :
Sum({$< ID ={"1"}>}current_Value/ predicted_Value) *100
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.
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
Solved it!
for anyone who wants reference here is the query i used :
Sum({$< ID ={"1"}>}current_Value/ predicted_Value) *100