Output a text if a condition is not met

[#1]

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!

[alexandros17]

Use a text box and in "Layout" tab in Show section use conditional with your condition

[#3]

Thanks for the reply! However, I'm using QlikSense and I can't seem to find the 'layout' tab.

[robert_mika]

Yes just type

if(sum(Units )>1,'N/A',sum(Units))

[jagan]

Hi,

Try like this

If(SomeCondition, 'N/A', Sum(MeasureName))

HOpe this helps you.

Regards,

Jagan.

[Kushal_Chawda]

=if(len(trim(Value))>0, sum(Values),'N/A')

[#7]

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.

[#8]

I used '*' in the IF statement and it worked...output showed the asterisk when the condition is not met...

[jagan]

Hi,

Ff you got the answer close this thread by giving Correct and Helpful Answers

Regards,

jagan.