Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Expression Help

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

1 Solution

Accepted Solutions
gandalfgray
Specialist II
Specialist II

something like this i think:

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

hth /gg

View solution in original post

5 Replies
gandalfgray
Specialist II
Specialist II

something like this i think:

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

hth /gg

gandalfgray
Specialist II
Specialist II

For subtracting dates I would try

DateA-DateB

/gg

gandalfgray
Specialist II
Specialist II

Hi AM

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

/gg

Not applicable
Author

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
Specialist II
Specialist II

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

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

hth

/gg