Help with Set Analysis

[#1]

Hi, I am trying to get my expression to count the number of invoice numbers (Invoice No) that's ages (Confusingly enough the title of the age column is Aged>30) are over 30 days.   I am new to Qlikview and it appears a Set Analysis is what I need to do but I'm struggling.

[reddy-s]

Hi Katie,

Use this expression:

count({< [Aged>30] = { ">30" } >} [Invoice No])

- Sangram

[Kushal_Chawda]

create the flag in script

if([Age>30] >30,1,0) as Age30_Flag

Now use the set analysis like below

=count({<Age30_Flag={'1'}>}[Invoice No])