topic Re: Counting MTD misses in QlikView

Counting MTD misses

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

Having some trouble think this one through.

Trying to count the number of days where Processed_Dash is less than Daily_Target_Dash

I would assume something like this

=Count({$<Processed_Dash < Daily_Target_Dash}, Month = {"$(=Month(Today()))"}, Year = {"$(=Year(Today()))"}>} distinct Date_Dash)

Re: Counting MTD misses

Anil_Babu_Samineni — Tue, 11 Jul 2017 17:39:31 GMT

May be create in script like below

If(Processed_Dash < Daily_Target_Dash, 1,0) as Flag

and expression is

Count({<Flag = {'1'}, Month = {'$(=Month(Today()))'}, Year = {'$(=Year(Today()))'}>} DISTINCT Date_Dash)

Or, One ugly expression this? But, I don't consider it is use

Count({<Processed_Dash = {"=Processed_Dash < Daily_Target_Dash"}, Month = {'$(=Month(Today()))'}, Year = {'$(=Year(Today()))'}>} DISTINCT Date_Dash)

Re: Counting MTD misses

sinanozdemir — Tue, 11 Jul 2017 17:48:20 GMT

Hi,

One solution could be Count(Distinct If(Processed_Dash < Daily_Target_Dash, Date_Dash)). Although, this may affect the calculation time depending on the number of records you have in your data model.

Thanks