Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Katie,
Use this expression:
count({< [Aged>30] = { ">30" } >} [Invoice No])
- Sangram
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])