Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
richard_chilvers
Specialist
Specialist

Conditional expression format

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

1 Solution

Accepted Solutions
rwunderlich

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

View solution in original post

3 Replies
sunny_talwar

What do you mean when you say Expression attributes?

tresesco
MVP
MVP

Try like:

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

rwunderlich

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

View solution in original post