set analysis variable construction

[drohm002]

Please see my data table below.  I want to create a variable that counts the number of 'ID's with days less than 90.  When I create the variable on my own, it gives me 6 as the answer, but really the answer should be 2 ID's.  I know I need to use the distinct function, but I just cant get the formula to work.  How can I accomplish this?  Thank you!

ID	days
1	5
1	5
1	5
2	20
2	20
2	20
3	100
3	100
3	100

[eru-alelo]

HI.

I've created a new discussion in the following group and with this title

Create Customer Billing Scenarios

All Locations> QlikView Forums & Resources> New to QlikView> Discussions.

[manoj217]

this is correct count function will count all the values <90 and with distinct used so it will count only unique values in a set analysis

= Count(DISTINCT {<days = {"<90"} >}ID)