Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

torunn_ringstad
New Contributor III

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

Re: Help with set analysis

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

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

2 Replies

Re: Help with set analysis

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

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

torunn_ringstad
New Contributor III

Re: Help with set analysis

Thank's a lot for your help, Alexandros!

It looks so simple when I see the solution.

Regard

Torunn

Community Browser