Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys!
I created the following table
Product | Day | Metric_1 | Objective | Threshold |
---|---|---|---|---|
1 | 1 | 0.56 | 0.5 | Y |
2 | 1 | 0.32 | 0.5 | N |
1 | 2 | 0.29 | 0.5 | N |
2 | 2 | 0.6 | 0.5 | Y |
What I want to do, is that if the value Metric_1 is higher than 0.5, put the value 'Y' in Threshold, otherwise, put 'N'.
I used the following formula in Threshold with no luck.
if([Metric_1] < 0.5,'Y','N')
it should be quite simple, isn't it?
I didn't add the formula for metric_1 here because I don't think its important, but I might be missing something crucial in Qlik as the condition seems pretty simple.
Kind regards!
Are you calculating the "If statement" during the Load or directly in the table ?
Have you declared the formula as an expression or as a calculated dimension ?
Hi,
The if statement looks correct
if([CONDITION] > 0.5, TRUEPART, FALSEPART )
A few things you can check is your condition and whether you need to give 0.5 as '0.5' (i.e If the value is numeric or text)
Are you calculating the "If statement" during the Load or directly in the table ?
Have you declared the formula as an expression or as a calculated dimension ?
Hi,
Are you trying to reference a Column Name in the chart, as opposed to a field?
I remember that you can do that in QlikView but I'm not sure that you can do that in Sense.
Can you try putting the formula from the Metric_1 expression into the Threshold expression (in place of [Metric_1])?
Dear Janani,
Thanks for your answer, unfortunately it was all my mistake! I was looking at the wrong metric.
Kind regards,
Alejandro.
Hello Michele,
I was looking at the wrong metric, it work as intended now!
Thanks for your answer .
Hey Adam!
It was all my fault, I was looking at the wrong metric.
Thanks for the answer.