how to convert if condition to set analysis

[vipin_mishra479]

Hi All,

count(distinct if( Date <= YearStartDate and Status = 3 and Area <> 'AP' and Area <> 'MH',EMPCODE))

here i have use year field in dimension.

[kaushiknsolanki]

Hi,

     Here is the set expression.

     Sum({<Date = {">=$(YearStartDate)"},Status = {"3"},Area -= {"AP","MH"}>}Distinct EMPCODE)

Regards,

Kaushik Solanki

[vipin_mishra479]

Hi koushik,

Expression is correct but in my Date field blank date is present i want include blank date also

but due to your expression it remove blank date expression

so please tell how to add blank date .

[kaushiknsolanki]

Hi,

     Why dont u give some dummy Date.

Regards,

Kaushik Solanki

[jonathandienst]

Hi

The expression you gave in your original post will also remove lines with a blank date. But to include with a set expression like this:

Count({<Date = {">=$(YearStartDate)"}, Status = {"3"}, Area -= {"AP","MH"}> +

<Date -= {"*"}, Status = {"3"}, Area -= {"AP","MH"}>} Distinct EMPCODE)

The -= will display a syntax error in the script editor, but you can ignore that (its a script editor bug).

HTH

Jonathan

[jagan]

Hi,

Try this expression

Sum({<Date -= {"*"} + {">=$(YearStartDate)"},Status = {"3"},Area -= {"AP","MH"}>}Distinct EMPCODE)

Hope it helps you.

Regards,

Jagan.