topic Set Analysis Error in QlikView

Set Analysis Error

gouthamkk — Mon, 12 May 2014 14:10:04 GMT

Hi,

I need assistance to convert below expression using Set Analysis

Current Expression:

Count(if(status='open', if ((target >= closedate), id)))

Note: closedate and target are date fields and are in same format.

I tried Below expression

Count ({<status= 'open', target = {">= closedate'}>} id)

But getting no values.

Request to assist

Re: Set Analysis Error

Anonymous — Mon, 12 May 2014 14:13:11 GMT

You have different quotes here

{">= closedate'}>}

Edit:

And, I prefer this approach:

Count ({<status= {'open'}, target = {"$(='>=' &date(closedate))"}>} id)

Re: Set Analysis Error

gouthamkk — Mon, 12 May 2014 14:25:22 GMT

Thank you very much. sorry it was a typo on my end for different quotes.

Quick question is it mandatory to have "date" before (closedate)

Re: Set Analysis Error

Anonymous — Mon, 12 May 2014 14:28:42 GMT

The date() function helps to keep format consistent. Without it, it often converts to integer. It maybe not necessary in your case, but I prefer to use it anyway.