Hi,
I am try to figure out if there is a way to add symbols for Thousand (K), Million (M), Billion (B), etc. in a Bar Chart to set values as data points. Currently, I am using the following formula, which works great in a Text Object but not in a Chart Object. This formula will add the symbols correctly but I run into a problem when the chart is displaying bars in both Millions and Thousands. I may have a bar that is 1.0M but if I have a bar that 999.9K the bar that is 999.9K will be larger than bar for 1.0M. This is due to the formula dividing by 1000, 1000000, etc depend on the value. Is there another formula that can be used to achieve this goal? Is this possible in Qlikview?
=num(sum( GROSS_REVENUE)/IF(sum( GROSS_REVENUE)>999999999.99 OR sum(GROSS_REVENUE)<-999999999.99,1000000000,IF(sum( GROSS_REVENUE)>999999.99 OR sum(GROSS_REVENUE)<-999999.99,1000000,
IF(sum(GROSS_REVENUE)>999.99 OR sum(GROSS_REVENUE)<-999.99,1000,1))),
IF(sum(GROSS_REVENUE)>999999999.99 OR sum(GROSS_REVENUE)<-999999999.99,'$#,###.0B;($#,###.0B)',
IF(sum( GROSS_REVENUE)>999999.99 OR sum(GROSS_REVENUE)<-999999.99,'$#,###.0M;($#,##0.0M)',
IF(sum(GROSS_REVENUE)>999.99 OR sum(GROSS_REVENUE)<-999.99,'$#,###.0K;($#,##0.0K)','$#,##0;($#,##0)'))))
Thanks in advance for your help.
Brian
