Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Set Analysis Expression Help

something like this i think:

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

hth /gg

5 Replies
gandalfgray
Not applicable

Set Analysis Expression Help

something like this i think:

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

hth /gg

gandalfgray
Not applicable

Set Analysis Expression Help

For subtracting dates I would try

DateA-DateB

/gg

gandalfgray
Not applicable

Set Analysis Expression Help

Hi AM

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

/gg

Not applicable

Re: Set Analysis Expression Help

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
Not applicable

Re: Set Analysis Expression Help

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

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

hth

/gg