topic Re: Can u help me on this Set Expression!!!!!! in QlikView

Can u help me on this Set Expression!!!!!!

Thu, 14 Aug 2014 02:05:30 GMT

Count(DISTINCT{<DOJ_EMP={'<=$(MSTR_Year)'},EMP_Status={'Active'}>+<DH_Year={'>=$(MSTR_Year)'}>}EMPLOYEE_CODE)

Am using using OR in between EMP_Status ,DH_Year can u any one correct me

whether my expresssion wrong or wright

same formula i replicated with if condition it is fine

Count(DISTINCT if((DOJ_EMP<= MSTR_Year and (IsNull(DH_Year) or DH_Year > MSTR_Year)),EMPLOYEE_CODE))

when u comes to the set expression getting the problem

Re: Can u help me on this Set Expression!!!!!!

jagan — Thu, 14 Aug 2014 02:18:56 GMT

Hi,

Try this expression

=Count(DISTINCT{<DOJ_EMP={'<=$(=MSTR_Year)'}, EMP_Status={'Active'}> + <DH_Year={'>=$(=MSTR_Year)'}>} EMPLOYEE_CODE)

If it not works then attach some sample file, what is the value in the MSTR_Year, DOJ_EMP and DH_Year do all those are in the same format?

Regards,

Jagan.

Re: Can u help me on this Set Expression!!!!!!

Thu, 14 Aug 2014 02:23:39 GMT

MSTR_year in not a variable if i remove $ symbol the data could not display

and more over thanx rly i tried with this expression but it does not help

Re: Can u help me on this Set Expression!!!!!!

evan_kurowski — Thu, 14 Aug 2014 02:24:03 GMT

Hello manjunath,

Try this:
Count(DISTINCT {<DOJ_EMP={"<=$(=Max(MSTR_Year))"},EMP_Status={Active}>+<DH_Year={">=$(=Max(MSTR_Year))"}>} EMPLOYEE_CODE)

Also make sure that the fields DOJ_EMP and MSTR_Year are the same data type and values, I'm assuming looking at your expression they both need to be year numbers. Use the Max() function to make your comparison against the maximum possible year, because if you pass the set-analysis multiple year values it won't understand against which possible value of many to begin it's comparison.