Set Analysis Expression

[gouthamkk]

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

[venkatg6759]

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)

[gouthamkk]

HI

Tried it and getting 0

[Greg_Williams]

Can you share the data source?

[venkatg6759]

Try this

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

[gouthamkk]

HI Greg,

I attached sample data set

[gouthamkk]

HI Venkat,

Getting 0 again

[venkatg6759]

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.

[gouthamkk]

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

[venkatg6759]

Check the attachment

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