Conditional expression format

[richard_chilvers]

I have an expression which might deliver a financial value which I'd like to display as '£##0' OR a percentage value, I'd like to display in the format '##%'.

Can I do this with expression attributes ?

Thanks

[sunny_talwar]

What do you mean when you say Expression attributes?

[tresB]

Try like:

If( <YourCondition>, Num(<Exp>, '##%'), Num(<Exp>, '£##0' ) )

[rwunderlich · Accepted solution]

tresesco‌ idea is what I would do also.  However, maybe slightly more efficient (esp if <exp> is complex) would be:

Num(<Exp>, If( <YourCondition>, '##%', '£##0' ) )

-Rob

http://masterssummit.com

http://qlikviewcookbook.com