topic Set Analysis Expression Help in QlikView

Set Analysis Expression Help

Thu, 10 Nov 2011 13:23:05 GMT

Hi,

I need help with a Set Analysis expression.

I need to count the number of cases where ticket age >7 days. I have a field (Age in days), which gives integer values 1,2,3..8,9, and so on.

So, basically I want to count(Case Id) where Age in Days >7.

I'm trying count({$<(AgeinDays >{7})>} CaseID). I know I'm commmitting an error here. Please help.

A second part to this question is if I have two date fields Date A and Date B in mm/dd/yyyy format and if I need to calculate the number of days between these two dates, what would be the expression?

Thanks

Set Analysis Expression Help

gandalfgray — Thu, 10 Nov 2011 13:39:43 GMT

something like this i think:

count({<AgeinDays={">7"}>} CaseID)

hth /gg

Set Analysis Expression Help

gandalfgray — Thu, 10 Nov 2011 13:42:42 GMT

For subtracting dates I would try

DateA-DateB

/gg

Set Analysis Expression Help

gandalfgray — Thu, 10 Nov 2011 14:38:56 GMT

Hi AM

If you could upload a small qvw with your problem I may be able to help you further,

/gg

Re: Set Analysis Expression Help

Thu, 10 Nov 2011 15:12:29 GMT

Hi GG,

I was making a small mistake on my end. The expression worked. But I want to ask an extension to this question.

I now know that for comparing with > I need to use = (">"). But what is the operator for not equal. e.g.

if I wanted to see count of all caseID where Age in Days is not equal to 7 days.

I tried <> and even != but it did not work.

Thanks

Re: Set Analysis Expression Help

gandalfgray — Thu, 10 Nov 2011 15:25:10 GMT

If you want all which is not equal to 7 days in Set analysis:

{<AgeinDays-={"7"}>}

hth

/gg