Showing $ in T/M/B in Pie Chart.

[#1]

Hi All,

I am using QV11 SR9. The pie chart is not showing up dollar amount automatically in thousands/millions/billions based on the number.

The money format is working fine in bar chart but the same is not working in pie chart.

I do not want to go for IF condition. Is it bug from qlikview? If so was is fixed any later version?

Please share your info/thoughts.

Regards,

Sai Krishna.

[kaushiknsolanki]

Hi Sai,

Can you explain in detail, exactly what have you done in pie chart and where you are putting $ sign.

Regards,

Kaushik Solanki

[#3]

Hi plz look into attachment.

[awhitfield]

Hi Sai,

can you upload a sample qvw that shows the issue?

Andy

[kaushiknsolanki]

Hi,

It wont work when you show the values in data points, but it will work on the legend.

Regards,

Kaushik Solanki

[#6]

Hi All,

Thanks UMAMAHESWARA REDDY for uploading sample file, I have modified it and attached it here.

Please see the attached example where first pie chart is showing data points as entire number but when same chart is displayed as Bar chart the numbers are shown in thousands. If the number value is increased it automatically converts to millions/billions.

I want same to happen in pie chart. I have achieved this using IF condition (Check third chart in attachment). can we do this without IF condition?

Regards,

Sai Krishna.

[MarcoWedel · Accepted solution]

Hi,

maybe one solution could be:

creating these variables in the script:

SET vSize = Div(Log10($1),3);

SET vFormatNumber = Dual(Num($1/Pow(10,3*$(vSize($1))),'#,##0.00')&' '&Pick($(vSize($1)),'T','M','B'),$1);

hope this helps

regards

Marco

[#8]

Thank You marcowedel!!

Qlik should have given this directly but not sure why it did not.

I tried but did not get, there is lot to learn for me.

[MarcoWedel]

you're welcome

glad it helped

regards

Marco

[#10]

Hi marcowedel,

This expression is not working when we use "," in set analysis i.e when we have more than one condition it is not working. Can you please suggest a solution for this kind of requirement?

=$(vFormatNumber(Sum(Spend))) is working, below is not working.

=$(vFormatNumber(Sum({<QuarterYear = {$(vCurrentQuarter), $(vLastQuarter1), $(vLastQuarter2), $(vLastQuarter3)}, Manager = {'ABC'}>}Spend)))

Regards,

Sai.