Set Analysis Expression Help

[#1]

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

AM

[gandalfgray · Accepted solution]

something like this i think:

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

hth /gg

[gandalfgray]

For subtracting dates I would try

DateA-DateB

/gg

[gandalfgray]

Hi AM

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

/gg

[#5]

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

AM

[gandalfgray]

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

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

hth

/gg