Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

How to convert same expression in set analysis.

Hi Team,

IF(NUM(FinCalculatedDate) = FLOOR(NUM(VCalculated_Date)) AND EmpStatus_Code = '3' and Leave_AbsenceDays = 0 ,Employee_Code)`

Regards,

QA

5 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     I think this is your need.

=Only({<FinCalculatedDate={$(=Date(VCalculated_Date))},EmpStatus_Code = {'3' },Leave_AbsenceDays = {0 }>} Employee_Code )

Hope it helps

Celambarasan

sona_sa
Creator II
Creator II
Author

Hi Celambarasan,

But i want to use this expression in Dimension Part so ONLY will not be usefull.

My requirement is NOT to count Employees satisfying the avobe condition,But to list them out...

Thanks,

QA

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Instead of restricting it in dimension part you can do it in the expression part.Is there any problem in doing it in expression part?

Celambarasan

jagan
Partner - Champion III
Partner - Champion III

Hi,

What are the Dimensions and expressions in your chart.  If you chart has any expression then use the Set analysis part of the expreesion and use Employee_Code as dimension.  The dimension is automatically filtered by the expression results.

Regards,

jagan.

Not applicable

Hi Akumar,

Just enclosed Celambarasan's expression in AGGR() function.

Example:

AGGR(Only({<FinCalculatedDate={$(=Date(VCalculated_Date))},EmpStatus_Code = {'3' },Leave_AbsenceDays = {0 }>} Employee_Code ), Employee_Code)

Regards,

Ronald