Is it a bug in Qlikview??? Please suggest any solution

[prasannarc_jbs2]

Dear All,

I am displaying a bar chart with values on datapoint.

Properties -> Expression tab -> Select Check Box ( Values on data point)

Problem defination:

I am displaying the values by applying symbols on it.

i.e.

Properties -> Numbers 

In Symbol i have placed '($)' sign

In Thousand Symbol i have placed 'Thousand(K$)' sign

In Million Symbol i have placed 'Million(K$)' sign

In Billion Symbol i have placed 'Billion (K$)' sign.

But when chart gets displayed

Please find the attached image for the problem statement...

Values on data points are getting in terms of dollars & Y-axis is Showing values in terms of Million(M$)

How can I resolve this problem?

How can I show the values on data point with respect to Y-axis.

i.e in Million dollars???

Pls suggest me any idea or any clue to achieve this…

Thanks.

[kaushiknsolanki]

Hi,

     If you want to show the values on data point in millions.

     All you have to do is divide the sum expression with 1 million.

     for example

     =Sum(Sales)/1000000

     Hope this is what you want.

Regards,

Kaushik Solanki

[prasannarc_jbs2]

Thanks Kaushik for your inputs...

But I want to calculate  the Sum(Sales) at runtime by the system.

i.e. system should decide wheather it is Million or Billion???

The display of values must be same...i.e if it is 10Million on scale..the values on bar should be 10Million not 10,000,000....

I think you got what I want to say....

I think it is a bug in Qlikview...just want to confirm???

Any other idea...

thanks again....

[#4]

Yes, same problem here...

[Anonymous]

Initially I thought it was a bug too. QV needs 'majority' of the values to be in millions to show in millions. Experiment with a data set like the following:

Year	Sales
2005	569,280
2006	5,983,409
2007	17,433,814
2008	28,571,730
2009	21,872,885
2010	3,641,791

You will realise that the chart will show in millions. if you say divide the expression by 10 then it will show in 000's.Hope this helps.