Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Help with set analysis

Hi!

I have the following expression with set analysis that works fine:

=sum({$*SLA_PL<SM9.INCIDENTSM1.OPEN_STATUS={'closed'},SM9.INCIDENTSM1.CATEGORY={'SERVICEREQUEST'},SM9.INCIDENTSM1.SUBCATEGORY2={'Kunde'},SM9.INCIDENTSM1.RUB_SLA_DEADLINE-={'=$(=NULL())'}>}SM9.INCIDENTSM1.COUNTER)

I need to put in one further condition, but have problems with the syntax.  I have a numeric date-field called  SM9.INCIDENTSM1.OPEN_TIME_NUM

I need to put in another test that says that only records with  SM9.INCIDENTSM1.OPEN_TIME_NUM  greater than 1st Feb 2013 shall be included.  The numeric value of this date shall be 41306.

How is the syntax in set analysis for testing that SM9.INCIDENTSM1.OPEN_TIME_NUM shall be greater than 41306?

I am very grateful for any help with this set analysis.

Best regards

Torunn

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

SM9.INCIDENTSM1.OPEN_TIME_NUM={'>41306'}

Add the condition to the others it have to work ...

View solution in original post

2 Replies
alexandros17
Partner - Champion III
Partner - Champion III

SM9.INCIDENTSM1.OPEN_TIME_NUM={'>41306'}

Add the condition to the others it have to work ...

Anonymous
Not applicable
Author

Thank's a lot for your help, Alexandros!

It looks so simple when I see the solution.

Regard

Torunn