topic Re: Count rows and columns in QlikView

Count rows and columns

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

Hi all,

I'am facing an issue and can't understand what i have wrong. I have a chart (CHART 1 in the snaphot below) with for each Day and Hour the time avability (0 to 60 min) of employee.

What i'm trying to achieve is to count the number of employee with 60 min as time avalility (number of rows) and the number of columns (corresponding to their qualification) with 60 min.

It's ok in the chart 2 for most part of hour, but for some i Don't have the real number. Qvw sample in attached file.

Thanks for your help

Re: Count rows and columns

tresB — Thu, 30 Apr 2020 11:01:30 GMT

Try exp like:

Count(DISTINCT if(Aggr(Sum(DISPO),DT, NUM_TH,ID_AGENT,ID_EMPLOI)=60, ID_AGENT)) and Count(DISTINCT if(Aggr(Sum(DISPO),DT, NUM_TH,ID_AGENT,ID_EMPLOI)=60, ID_EMPLOI))

Re: Count rows and columns

sergio0592 — Thu, 30 Apr 2020 12:08:09 GMT

Perfect, thanks!