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

Strange Currency Format problem when relative option selected in other column

Wed, 13 Mar 2013 13:51:17 GMT

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!

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

CELAMBARASAN — Wed, 13 Mar 2013 13:57:08 GMT

Can you upload the file?

I didn't faced that scenario

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

Thu, 14 Mar 2013 09:07:27 GMT

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

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

Gysbert_Wassenaar — Thu, 14 Mar 2013 10:25:55 GMT

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.