Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Strange Currency Format problem when relative option selected in other column

Hi,

I have a Statistics Table with the following columns:

- Sales (Currency). It contains the following expression:

num

(Sum (Sales*CurrencyChange),CurrencyFormat)

-  Marketing Budget (Number). RELATIVE field (%)

My problem is that when RELATIVE checkbox is selected for Marketing Budget, CurrencyFormat is not correctly displayed. Otherwise it works perfectly.Why the Relative attribute causes this behaviour in another field? How to fix it?

Thanks in advance!

3 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Can you upload the file?

I didn't faced that scenario

Not applicable
Author

I have uploaded a dummy example where you can see this behaviour .. Any hint?

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

That is weird. I think that's a bug. As a workaround you could use Sum(marketingBudget)/Sum(total marketingBudget) instead of using the relative option and format it as a percentage.


talk is cheap, supply exceeds demand