I have a straight table to show the details of Active employees.
I have used this expression in "EMPLY_ID" field "=if(EmpActive=1,EMPLY_ID)" and unchecked "Show null values" which is working exactly as the way i wanted.
I would like to know if i can use Set Analysis for this purpose?
The reason being, i would like to filter also by another condition.
I am also facing another issue. I have put a filter "EmpType" which has three distinct values D, F & L. I'm showing the EmpType as one of the column in this table. But when i select "F" type in filter, my table is not showing only F type employees. It still shows all records.
Is this due to the condition i put in EMPLY_ID field?
Solved! Go to Solution.
Where to use this? I m using this in expression.
I also tried below and it worked. However, i would like to use Set Analysis
if(EmpActive=1 and upper(NATION_TYPE)='NATIONAL',EMPLY_ID)
From your response to Kaushik above, it seems you are using calculated dimension. You need to use his expression as an expression, and not a dimension.
If you share a sample, one of us might be able to show you what exactly you need to do here