Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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.

Community Browser