topic Re: Conditional expression format in QlikView

Conditional expression format

richard_chilvers — Thu, 01 Sep 2016 11:22:35 GMT

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

Re: Conditional expression format

sunny_talwar — Thu, 01 Sep 2016 11:26:11 GMT

What do you mean when you say Expression attributes?

Re: Conditional expression format

tresB — Thu, 01 Sep 2016 11:28:24 GMT

Try like:

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

Re: Conditional expression format

rwunderlich — Thu, 01 Sep 2016 12:40:00 GMT

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