topic Re: Set Analysis Expression in QlikView

Set Analysis Expression

gouthamkk — Wed, 18 Jun 2014 20:05:01 GMT

HI Experts,

I am trying to replace IF condition using set analysis, attached is the sample data set with QVW

I have 2 textboxes

1) condition using IF

2) replacing IF with Set Analysis

Request for help

Thanks

Kumar

Re: Set Analysis Expression

venkatg6759 — Wed, 18 Jun 2014 20:14:16 GMT

Create a variable for your approval date

Let say vApprovalDate = date(ApprovalDate, 'MM/DD/YYYY hh:mm;ss[.ffff] TT')

then

Count({<state={'CA'}, Joindate = {"'>=$(vApprovalDate)"}>}ID)

Re: Set Analysis Expression

gouthamkk — Wed, 18 Jun 2014 20:21:34 GMT

Tried it and getting 0

Re: Set Analysis Expression

Greg_Williams — Wed, 18 Jun 2014 20:27:43 GMT

Can you share the data source?

Re: Set Analysis Expression

venkatg6759 — Wed, 18 Jun 2014 20:33:50 GMT

Try this

Count({$<state={'CA'}, Joindate *= {'>=$(vApprovalDate)'}>}ID)

Re: Set Analysis Expression

gouthamkk — Wed, 18 Jun 2014 20:41:44 GMT

HI Greg,

I attached sample data set

Re: Set Analysis Expression

gouthamkk — Wed, 18 Jun 2014 20:45:42 GMT

HI Venkat,

Getting 0 again

Re: Set Analysis Expression

venkatg6759 — Wed, 18 Jun 2014 20:53:06 GMT

check the date format

it should be =date(ApprovalDate, 'MM/DD/YYYY hh:mm:ss[.ffff] TT')

Next where is field called ID in the sample data which you provided.

Re: Set Analysis Expression

gouthamkk — Wed, 18 Jun 2014 21:05:24 GMT

Apologies forgot to add id and I did try in the format you gave, I am getting 0

Re: Re: Set Analysis Expression

venkatg6759 — Wed, 18 Jun 2014 21:16:03 GMT

Check the attachment

there is only one date that is higher than the approvaldate in joindate

Re: Set Analysis Expression

gouthamkk — Thu, 19 Jun 2014 14:38:07 GMT

HI Venkat,

I am attaching a qvw file with updated columns(ID) and placed 2 text boxes.

1) With IF

2) trying to replace IF using set analysis

Re: Re: Set Analysis Expression

venkatg6759 — Thu, 19 Jun 2014 15:06:00 GMT

Check the attached solution .

Let me know

Re: Set Analysis Expression

gouthamkk — Thu, 19 Jun 2014 15:17:15 GMT

Thanks a lot, this one works