topic Re: Wrong numbers with a histogramm in QlikView

Wrong numbers with a histogramm

Mon, 15 Jul 2013 08:15:02 GMT

Hi there,

I have a problem with values in a histogramm or more precisely I have a probleme when I select many records.

For diferents reasons i have to select 2 number of year but I put only one number of year as a dimension. I think that's the problem.

Please find attached 3 screenshots to understand the situation.

In the third screenshot,I would like to keep the 9,5% and 10,23% but i don't know how to do that.

Thank you for your help.

Re: Wrong numbers with a histogramm

kaushiknsolanki — Mon, 15 Jul 2013 08:32:31 GMT

Hi,

Try this expression.

count(NUM_JOUR)/((Count(IDF_AGENT)/12)*365)

Regards,

Kaushik Solanki

Re: Wrong numbers with a histogramm

Mon, 15 Jul 2013 08:55:56 GMT

Hi Kaushik,

Thank you for your help but your expression doesn't give the right number neither.

Re: Wrong numbers with a histogramm

kaushiknsolanki — Mon, 15 Jul 2013 08:59:52 GMT

Kindly post your qvw file.

Regards,

Kaushik Solanki

Re: Wrong numbers with a histogramm

Mon, 15 Jul 2013 09:02:36 GMT

Sorry i can't because there are some confidential data but I can give you more informations if you need so.

Re: Wrong numbers with a histogramm

kaushiknsolanki — Mon, 15 Jul 2013 09:04:04 GMT

Hi,

Its ok i can understand Try below expression.

count(NUM_JOUR)/((Count(total IDF_AGENT)/12)*365)

Regards,

Kaushik Solanki

Re: Wrong numbers with a histogramm

Mon, 15 Jul 2013 09:06:55 GMT

thank you for understanding.

It doesn't work. My expression is correct if I select only one year. The problem appears when more than one year is selected..

Re: Wrong numbers with a histogramm

kaushiknsolanki — Mon, 15 Jul 2013 09:11:05 GMT

Hi,

Can you do one thing.

Just send the values of 2009 and 2010 for the Num_Jour and IDF_Agent

Regards,

Kaushik Solanki

Re: Wrong numbers with a histogramm

Mon, 15 Jul 2013 09:22:53 GMT

NUM_JOUR 2009 : 112628 IDF_AGENT 2009 : 26944 IDF_AGENT{$<NUM_ANNEE>} 2009 : 1 183 817

NUM_JOUr 2010 : 123732 IDF_AGENT 2010 : 26801 IDF_AGENT{$<NUM_ANNEE>} 2010 : 1 209 762

Re: Wrong numbers with a histogramm

kaushiknsolanki — Mon, 15 Jul 2013 09:30:32 GMT

Hi,

I guess the calulcation is wrong somewhere.

To explain with your example.

For 2009 it will be

112628 / ((1183817)/12)*365)

The out put of this is 0.31% not 9.51%

Kindly correct if I am wrong.

Regards,

Kaushik Solanki

Re: Wrong numbers with a histogramm

Mon, 15 Jul 2013 09:35:43 GMT

Sorry I forgot to precise that 1183817 is count(IDF_AGENT)/12*365.

So it is 112628/1183817=9,5 %.

Re: Wrong numbers with a histogramm

kaushiknsolanki — Mon, 15 Jul 2013 09:38:04 GMT

Hi,

Can you give the count value for count(IDF_AGENT) for 2009,2010 and when you select both what is the count.

Regards,

Kaushik Solanki

Re: Wrong numbers with a histogramm

Mon, 15 Jul 2013 09:43:18 GMT

2009 : count(idf_agent)=26944

2010 count(idf_agent)=26801

When 2009 and 2010 are selected : 2009 : count (idf_agent)= 31382 2010 : count(idf_agent)=31456

Re: Wrong numbers with a histogramm

kaushiknsolanki — Mon, 15 Jul 2013 12:00:06 GMT

Hi,

Here is the problem,

You can see that the values are changing, which they shouldnt.

It will not be possible to say whats going wrong unless you provide some data.

Regards,

Kaushik S0lanki

Re: Wrong numbers with a histogramm

Mon, 15 Jul 2013 14:38:53 GMT

I found something I was doing wrong. Indeed i was counting a key value so the number came from two field. I corected that point but I stil don't get what I want. I can't have 9,51% and 10,23%..