topic Different dimensions in count in QlikView

Different dimensions in count

Tue, 12 Jun 2012 07:09:53 GMT

Hi to everyone,

I need help in determining a value which is the ratio between a sum of sales in a month and a count of a distinct number of employees that are prensent in a plant on that month.

The expression I am using is:

=sum(PROD_Euro_BW) / (Count (DISTINCT {< YearP = {PROD_Year_BW}, MonthP = {PROD_Month_BW}>} ID ))

Now PROD_Year_BW and PROD_Month_BW are the dimentions used to determine the sum of PROD_Euro_BW but ID depends on Year and Month. The result of this ratio is a linear chart whose X axis is a date made from DATE(MakeDate(PROD_Year_BW,PROD_Month_BW),'yyyy-MM') and Y axis is the ratio.

I hope this is clear and that someone can give me a hand on this as I am really stuck on it.

Thank you in advance for any help.

Re: Different dimensions in count

Wed, 13 Jun 2012 06:38:22 GMT

Hi,

no-one can give me an input on this?

Thanks

Re: Different dimensions in count

rohit214 — Wed, 13 Jun 2012 07:03:49 GMT

Hi,

so u want count of distinct employee for currrent month or whole months.

thnx

rohit

Re: Different dimensions in count

Wed, 13 Jun 2012 07:11:32 GMT

Hi,

I need to count the total number of employees for each month. The problem is that PROD_Euro_BW depends on PROD_Year_BW and where as ID depends on YearP and the two time dimensions have no correlation.

Also I am using this count in a Graph where the time dimension is based on PROD_Year_BW+PROD_Month_BW.

Table Revenue ( PROD_Euro_BW, PROD_Year_BW, PROD_Month_BW....... )

Table Employees ( ID, YearP, MonthP ..... )

I hope it is clear 😉

Thanks