Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! 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

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