topic Get count of values in QlikView

Get count of values

Fri, 12 Oct 2012 08:06:15 GMT

How to get count of field values which are less than selected value of same field.

Re: Get count of values

Fri, 12 Oct 2012 12:32:18 GMT

Hello:

Check the attached App for the similar work around.

Hope this helps,

Narasimha K

Re: Get count of values

johnw — Fri, 12 Oct 2012 22:52:49 GMT

I don't think you need the variable. And we may have to decide what to do if more than one or if none are selected. For the sake of argument, I'll go with less than the minimum selected, and 0 if none are selected:

count({<Item={"<$(=min(Item))"}>} Item)

Or if it's a key field:

count({<Item={"<$(=min(Item))"}>} distinct Item)