Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Is it possible for a measure to output a text if a condition is not met? I have an IF statement for a condition that when satisfied will sum all values otherwise, it should output "N/A".
Thanks!
Use a text box and in "Layout" tab in Show section use conditional with your condition
Thanks for the reply! However, I'm using QlikSense and I can't seem to find the 'layout' tab.
Yes just type
if(sum(Units )>1,'N/A',sum(Units))
Hi,
Try like this
If(SomeCondition, 'N/A', Sum(MeasureName))
HOpe this helps you.
Regards,
Jagan.
=if(len(trim(Value))>0, sum(Values),'N/A')
Thanks for all the helpful info.
I already included 'N/A' in my IF statement previously but for some reason the output when the condition is not met shows '-' instead. I tried changing 'N/A' to other characters but the output still shows '-'. I also tried using the chr() function but it didn't work as well.
I used '*' in the IF statement and it worked...output showed the asterisk when the condition is not met...
Hi,
Ff you got the answer close this thread by giving Correct and Helpful Answers
Regards,
jagan.