topic Re: OR Statement within Set Analysis in QlikView

OR Statement within Set Analysis

Wed, 10 Jun 2015 03:14:51 GMT

What is the correct syntax of an OR statement of two different field conditions in set analysis?

Essentially what I want:

Num(Count(distinct {$<DateType = {'RequestedDate'}, Date = {'>=$(v30Days)'},REQUEST_STATUS_GENERIC={'Open'},REQUEST_ORIGINATION = {'Customer'}, REQUEST_SLA_RESPONSE_PASTDUE = {'N'} OR REQUEST_EST_SLA_COMPLETION_TIME = {'<vCurrentDate)'}>} REQUEST_ID),'#,###')

Re: OR Statement within Set Analysis

settu_periasamy — Wed, 10 Jun 2015 03:33:25 GMT

Hi,

Try this

Num(Count(DISTINCT {$<DateType = {'RequestedDate'},

Date = {'>=$(v30Days)'},REQUEST_STATUS_GENERIC={'Open'},

REQUEST_ORIGINATION = {'Customer'},

REQUEST_SLA_RESPONSE_PASTDUE = {'N'} >} REQUEST_ID)

Count(DISTINCT {$<DateType = {'RequestedDate'},

Date = {'>=$(v30Days)'},REQUEST_STATUS_GENERIC={'Open'},

REQUEST_ORIGINATION = {'Customer'},

REQUEST_EST_SLA_COMPLETION_TIME = {'<vCurrentDate)'}>} REQUEST_ID)

,'#,###')

Re: OR Statement within Set Analysis

Wed, 10 Jun 2015 03:46:29 GMT

Unfortunately that would cause duplicates if a request meets both criteria.

Re: OR Statement within Set Analysis

PrashantSangle — Wed, 10 Jun 2015 03:54:32 GMT

Hi,

You can try

Num(

Count(distinct {$<DateType = {'RequestedDate'}, Date = {'>=$(v30Days)'},REQUEST_STATUS_GENERIC={'Open'},REQUEST_ORIGINATION = {'Customer'}, REQUEST_SLA_RESPONSE_PASTDUE = {'N'} >

<DateType = {'RequestedDate'}, Date = {'>=$(v30Days)'},REQUEST_STATUS_GENERIC={'Open'},REQUEST_ORIGINATION = {'Customer'},REQUEST_EST_SLA_COMPLETION_TIME = {'<vCurrentDate)'}> } REQUEST_ID),'#,###')

Regards

Re: OR Statement within Set Analysis

Wed, 10 Jun 2015 03:57:55 GMT

So if a request met both criteria, would the Distinct only allow for it to be counted once?

Also, is there no true syntax for an OR statement?

Re: OR Statement within Set Analysis

PrashantSangle — Wed, 10 Jun 2015 04:02:30 GMT

Have you tried above solution. In Set Analysis + works like OR Operator

Try it and let me know.

IF possible post your sample app.

Regards

Re: OR Statement within Set Analysis

Wed, 10 Jun 2015 04:14:54 GMT

You are right, I had brain fart.

Thank you!