topic Re: Amount Format in QlikView

Amount Format

Tue, 21 Jul 2015 16:10:44 GMT

Hi All,

Greetings for the day.

I have one bar chart which represents the amount based on type and i have two text boxes to show data in dollars and percentage.

If i click on dollar button then values on bar should show like $ 100..If i click on Percentage button then it should show values on bars with percentage like 20 %..

For this i have created one expression and devided by variable values(based on selection either % or $).

But the corresponding $ and % values are not displaying in bar chart.

Could you please anybody take a look into this. I have attached sample QVW also.

Thanks,

Chiru

Re: Amount Format

sunny_talwar — Tue, 21 Jul 2015 16:20:38 GMT

Try as attached

Best,

Sunny

Re: Amount Format

Wed, 22 Jul 2015 13:30:14 GMT

Hi Sunny,

Thanks for your Help.

All is fine but when we switch to % then axis is showing as 0.0 to 1.2 instead of showing 0 to 100.

Is there option to change this

Thanks,

Chiru

Re: Amount Format

sunny_talwar — Wed, 22 Jul 2015 13:35:38 GMT

Try attached:

Re: Amount Format

settu_periasamy — Wed, 22 Jul 2015 14:20:07 GMT

Hi,

one more way, without using the if condition in expression,

like Num(Sum({<Type={'Target'}>}Amount)/$(vDlr),$(vDec))

PFA for reference..

Re: Amount Format

Sat, 25 Jul 2015 17:39:54 GMT

HI Sunny,

Thanks! This is exactly what i expected.

Thanks,

Chiru

Re: Amount Format

sunny_talwar — Sat, 25 Jul 2015 17:43:45 GMT

Awesome

I am glad I was able to help.

Please mark the correct answer if you have got the answer you were expecting.

Best,

Sunny