topic Re: Set Analysis using less than issue in QlikView

Set Analysis using less than issue

Tue, 10 Nov 2015 18:54:34 GMT

I need to count the number of items that have a duration of less than 259200. I am trying this using set analysis but I am struggling.

Need to count the field "number", If "inc_business_duration" is equal to or less than 259200.

No matter what I try I cannot seem to get this one right.

sunny_talwar — Tue, 10 Nov 2015 18:57:49 GMT

May be this:

Count({<inc_business_duration = {'<=259200'}>}number)

sunny_talwar — Tue, 10 Nov 2015 18:58:39 GMT

Or this:

=Count(If(inc_business_duration <= 259200, number))

maxgro — Tue, 10 Nov 2015 19:00:01 GMT

count({$ <inc_business_duration={"<=259200"}>} number)