Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Strange Currency Format problem when relative option selected in other column

Can you upload the file?

I didn't faced that scenario

Not applicable

Re: Strange Currency Format problem when relative option selected in other column

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

MVP & Luminary
MVP & Luminary

Re: Strange Currency Format problem when relative option selected in other column

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