Chart Object - Number Symbols

Tue, 08 Apr 2014 16:59:44 GMT

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

Re: Chart Object - Number Symbols

its_anandrjs — Tue, 08 Apr 2014 17:09:18 GMT

In chart it is also working in the chart properties -> Number -> select Expression Default.

Re: Chart Object - Number Symbols

nizamsha — Tue, 08 Apr 2014 17:22:10 GMT

PFA

topic Re: Chart Object - Number Symbols in QlikView

Chart Object - Number Symbols

Re: Chart Object - Number Symbols

Re: Chart Object - Number Symbols