topic Re: Monthwise Data not proper in chart in QlikView

Monthwise Data not proper in chart

Thu, 10 Apr 2014 04:52:26 GMT

Hi All,

I have a query. In my application, the text box is giving the correct result on month selection. But when i take the same expression in a chart with month as a dimension, it is not giving the correct result. For eg, for the month of April 2014, total headcount as on first day of month is 8915 and total headcount as on last day of month is 8914, which is correct in text boxes. But in the chart for the same it is giving incorrect values.Any suggestions on this friends?

Regards,

Raghu

Re: Monthwise Data not proper in chart

Thu, 10 Apr 2014 05:15:58 GMT

Hi,

Your chart is also showing correct da as showing in textboxes

Just check the expression total for both of your expressions and see.

Here your data is for ason date means if you select year=2014 and month=jan, the figure is for 2014 Jan,

If you select 2014,feb, the figure is for 2014 till feb and so on

Re: Monthwise Data not proper in chart

Thu, 10 Apr 2014 06:51:51 GMT

Hi Ravi,

Thanks for your reply. Yes the total value is right. But i need against each month the data should be same as the one which text box is showing.

Re: Monthwise Data not proper in chart

Mon, 14 Apr 2014 08:13:59 GMT

use TOTAL keyword in your expression like the following:

=(Count(Total DISTINCT{<Date={"<=$(=MonthEnd(vMaxDate,-1))"},Flag={'Joined'},JYear=,Month=>}Pers.no.)

-Count(Total DISTINCT{<Date={"<=$(=MonthEnd(vMaxDate,-1))"},Flag={'Left'},JYear=,Month=>}Pers.no.))

Hope it will work.......

Re: Monthwise Data not proper in chart

Mon, 14 Apr 2014 09:23:57 GMT

In your text box the data you are showing is sum of all the omnth as you have included {Month=} condition in expression.

So it is excluding the month selection.

But in your table box you are showing values across months , hence both the values are not matching.

Change your text box expression to affect by month like:

Count(DISTINCT{<Date={"<=$(=MonthEnd(vMaxDate,-1))"},Flag={'Joined'},JYear=>}Pers.no.)
-Count(DISTINCT{<Date={"<=$(=MonthEnd(vMaxDate-1,-1))"},Flag={'Left'},JYear=>}Pers.no.))

Then only you can check the values across table and text box.

Hope this will help you..!

Re: Monthwise Data not proper in chart

Tue, 15 Apr 2014 06:15:54 GMT

Hi Saranya,

Thanks for your suggestion. I tried the TOTAL.. but with that, all months gives the same value in the chart.

Re: Monthwise Data not proper in chart

tresB — Tue, 15 Apr 2014 06:24:35 GMT

I guess, this is second thread with similar requirement by you. Please explain your requirement in more details. May be, it would be better if you can give some expected output for different selections or non-selections.

Re: Monthwise Data not proper in chart

Tue, 15 Apr 2014 06:26:53 GMT

I think the way you are doing validation for data is incorrect.

Because your expression in chart and text box can't be the same.

In your text box the data you are showing is sum of all the omnth as you have included {Month=} condition in expression.

So it is excluding the month selection.

But in your table box you are showing values across months , hence both the values are not matching.

Change your text box expression to affect by month like:

Count(DISTINCT{<Date={"<=$(=MonthEnd(vMaxDate,-1))"},Flag={'Joined'},JYear=>}Pers.no.)
-Count(DISTINCT{<Date={"<=$(=MonthEnd(vMaxDate-1,-1))"},Flag={'Left'},JYear=>}Pers.no.))

Then only you can check the values across table and text box.

Hope this will help you..!

Re: Monthwise Data not proper in chart

Tue, 15 Apr 2014 06:49:12 GMT

have u added 'TOTAL' in both two expressions?

Re: Monthwise Data not proper in chart

Tue, 15 Apr 2014 07:03:17 GMT

Hi Tresesco,

The requirement is like this..

I need to calculate number of employees working in the organization. It has to be shown month wise. Like at the first day of month, how many employees are working in the organization.Similarly at the last day of month how many employees are working. For eg, for the month of April 2014, total headcount as on first day of month is 8915 and total headcount as on last day of month is 8914, which is correct in text boxes. But in the chart for the same it is giving incorrect values. Similarly for eg, in July 2014, total headcount as on first day of month should be 9041 and total headcount as on last day of month should be 9236.

Re: Monthwise Data not proper in chart

Tue, 15 Apr 2014 07:04:05 GMT

Yes Saranya, I have added TOTAL in both the expressions. Its not giving correct result