topic Re: Distinct Count with If in QlikView

Distinct Count with If

Tue, 01 Apr 2014 17:08:39 GMT

Hi All,

I am struggling to convert the expression =Count(If(Enroute>=0,[Truck Reg],0)) into one which produces a distinct count of the field Truck reg whenever the condition Enroute>=0 is met.

Can someone assist with a tweak.

Thanks

Re: Distinct Count with If

Emmanuelle__Bustos — Tue, 01 Apr 2014 17:12:39 GMT

Have you tried

=If(Enroute>=0, Count([Truck Reg]),0)

Re: Distinct Count with If

Tue, 01 Apr 2014 17:20:33 GMT

Hi Emmanuelle,

For some reason reason, the app doesn't quite like it and it produces zero, where as my first expression produces 563

Thanks

Re: Distinct Count with If

joggiek — Tue, 01 Apr 2014 17:22:00 GMT

Try this

=Count(Distinct(If(Enroute>=0,[Truck Reg],0)))

Re: Distinct Count with If

Emmanuelle__Bustos — Tue, 01 Apr 2014 17:23:38 GMT

If your first expression is working then add Disctinct:

=Count(Distinct(If(Enroute>=0,[Truck Reg],0)))

Re: Distinct Count with If

jerem1234 — Tue, 01 Apr 2014 17:39:36 GMT

Why not set analysis?

=Count({<Enroute = {'>=0'}>} distinct [Truck Reg])

Hope this helps!