Help with set analysis

Anonymous — Sun, 03 Feb 2013 13:17:01 GMT

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

Re: Help with set analysis

alexandros17 — Sun, 03 Feb 2013 13:36:23 GMT

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

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

Re: Help with set analysis

Anonymous — Sun, 03 Feb 2013 13:49:24 GMT

Thank's a lot for your help, Alexandros!

It looks so simple when I see the solution.

Regard

Torunn

topic Re: Help with set analysis in QlikView

Help with set analysis

Re: Help with set analysis

Re: Help with set analysis