topic Re: Compare count! in QlikView

Compare count!

Fri, 09 Jun 2017 10:30:17 GMT

My count is coming into field1.

and I want to create report where my column will be like count(Field1)<10 , count(Field1)>10

And I am writing expression like this , But it's not working,

1. =count(If(field1 < 10 ), ID))

2. =count(If(field1 > 10 ), ID))

Re: Compare count!

micheledenardi — Fri, 09 Jun 2017 10:35:58 GMT

Hi Shubham,

just simpy use set analysis:

count({<[field1]={"<10"}>} ID)

and

count({<[field1]={">10"}>} ID)

Re: Compare count!

micheledenardi — Fri, 09 Jun 2017 10:44:33 GMT

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,

Re: Compare count!

Fri, 09 Jun 2017 10:53:54 GMT

Thanks Michele.

That works