topic Re: Count Total Distinct Help in QlikView

Count Total Distinct Help

haneeshmarella — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

Please correct me in the below formula.

Target Cartons = (Hours/count(TOTAL <Name> DISTINCT DATE_TIME))*29

I am trying to distribute the hours worked for each hour and calculate target based on it. If ABC worked 4 hours, it should consider only 8/12 date and DATE_TIME of 8/12 and distribute among it and multiply by 29, so 1*29 = 29. But with above formula, it also counts the DATE_TIME of previous day and hence gives the output in the below second table.

How do I correct the formula so as to get only the count of current days hours?

Re: Count Total Distinct Help

vishsaggi — Wed, 15 Aug 2018 21:39:11 GMT

May be add Date field like

Target Cartons = (Hours/count(TOTAL <Name> {<Date = {[$(=Date(DATE_TIME, 'M/DD/YYYY')))]} >} DISTINCT DATE_TIME))*29

Re: Count Total Distinct Help

haneeshmarella — Wed, 15 Aug 2018 21:43:05 GMT

No change in output, gives the same result.

Re: Count Total Distinct Help

vishsaggi — Wed, 15 Aug 2018 21:49:53 GMT

Can you share this sample file to look into?

Re: Count Total Distinct Help

haneeshmarella — Wed, 15 Aug 2018 21:55:38 GMT

I think I got it, changed from Name to Date

(Hours/count(TOTAL <Date> DISTINCT DATE_TIME))*29

Thank you for your responses though Vishwarath.