topic Re: TOTAL Count help in QlikView

TOTAL Count help

danielnevitt — Tue, 14 Mar 2023 12:40:00 GMT

Dear all,

I have the below expression:

Count({<[Late/OnTime]={`Late`},Trade_Create_monthyear={`Jan 2023`}>}[Trader Full Name])/Count(TOTAL <Trade_Create_monthyear={`Jan 2023`}>[Trader Full Name])

I'm trying to calculate the Count of Late where create date is Jan 2023 and then the TOTAL count of all trades where create date is Jan 2023. I require these calculations at a trader level.

Any help with the above is much appreciated.

Regards,
Daniel

Re: TOTAL Count help

BrunPierre — Tue, 14 Mar 2023 14:05:01 GMT

Count({$<[Late/OnTime]={'Late'}, Trade_Create_monthyear={'Jan 2023'}>} [Trader Full Name])
/
Count({$<Trade_Create_monthyear={'Jan 2023'}>} TOTAL [Trader Full Name])

Re: TOTAL Count help

Marijn — Tue, 14 Mar 2023 15:09:50 GMT

I think you could discard the TOTAL and just count all the 'Late' records divided by all the records in 'Jan 2023'?
Like this:

Count({<[Late/OnTime]={'Late'},Trade_Create_monthyear={'Jan 2023'}>}[Trader Full Name]) / Count(<Trade_Create_monthyear={'Jan 2023'}>[Trader Full Name])

If you need it on a trader level and want to use the total function, I think you have to exclude the Trader from the total function. Like this:

Count({<[Late/OnTime]={'Late'},Trade_Create_monthyear={'Jan 2023'}>}[Trader Full Name]) / Count(TOTAL <Trader Full Name> <Trade_Create_monthyear={'Jan 2023'}>[Trader Full Name])