Set Analysis for Less than Equal

[#1]

Can someone assest me with the Set Analysis for the following fields and varables? It seems so simple and yet all the discussions make it so hard.

EmployeeDirectory.DOH <= vLastYear

[#2]

Hey, I just wanted to thank both Mayil and Celambarasan for all the assistance on this issue. The reason I wasn't getting the number I wanted because I had to subtract one count from the other. It seems so silly that I didn't think of that, but I am in and out of Qlikview so often that I forget. I can't tell you how nice it was to be able to reach out and find the assistance.

Thank you so much,

Cindy

[CELAMBARASAN]

Hi,

Comma(,) does Or operation whereas *(Intersection operator) does and operation.

[#4]

Celambarasan,

Count last Year column is what I get when I use the *(Intersection operator) As you can see the and portion of the statement isn't picking up the NLE Year of blanks. Any ideas why?

[CELAMBARASAN]

Hi,

Null cannot be compared using set analysis

You can use NLE_Year-={*} to get the blank values

[#6]

So this is the new expression and I get the same as the above example.

=Count({<DOH_Year = {'<=$(=vLastYear)'}>*< NLE_Year -= {'<$(=vLastYear)'}>*< NLE_Year -= {'*'}>} EmployeeDirectory.Name)

Any ideas?

[CELAMBARASAN]

You need to write separate expressions

=Count({<DOH_Year = {'<=$(=vLastYear)'}>*< NLE_Year -= {'<$(=vLastYear)'}>} EmployeeDirectory.Name)+Count({<DOH_Year = {'<=$(=vLastYear)'}>*< NLE_Year -= {'*'}>} EmployeeDirectory.Name)

[#8]

Celambarasan,

Can I do more than one and operation like this:

=Count({<EmployeeLog.EmployeeDate={"$(=max(EmployeeLog.EmployeeDate))"},DOH_Year = {'<=$(=vLastYear)'}>*< NLEIndicator ={'0'}>} EmployeeLog.Name)

Or how do I add the max date to this expression?