topic Help with Set Analysis in QlikView

Help with Set Analysis

Wed, 02 Dec 2015 14:18:07 GMT

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.

Re: Help with Set Analysis

reddy-s — Wed, 02 Dec 2015 17:23:39 GMT

Hi Katie,

Use this expression:

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

- Sangram

Re: Help with Set Analysis

Kushal_Chawda — Wed, 02 Dec 2015 17:36:51 GMT

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])