Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Different number format; same expression?

I'm trying to add a Total sales column along with a horizontally presented expression, which works, but I can't seem to format the Total column as currency seperate from the percentages. Here is my single expression:

If(SecondaryDimensionality() = 0, If(Sum([Discount Percent]) > 0, Money(Sum([Sales Amount]))), [Discount Percent])

And the result:

Capture.PNG

Any suggestions?

UPDATE:

This is what I went with. Probably not the most efficient, but it works:

If(SecondaryDimensionality() = 0, If(Sum([Discount Percent]) > 0, Money(Sum([Sales Amount]))), (Num([Discount Percent] * 100, '##.0')) & '%' )

Hope this helps someone in the future.

0 Replies