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: 
Not applicable

How to bypass an expression in set analysis instead of field?

Dear All,

I have  to calculate  simulation of salary i.e. salary of all the employees selected by user should be deducted from the salary amount of all employess.

For which first i would have to calculate salary of all employess which will not change on any employee selections.

For these i can by-pass employee field in set analysis expression,but the employee code which iam getting is through some other expression.

So now how to by-pass an expression in a set analysis expression.

Following is my normal Set Expression where Employee feild is by-passed

"num(((sum({1} {<EMPLOYEE_Code=,
EMPLSTATUS = {3},FinYear = {"$(vMaxFinYear)"},Year_Month_new = {"$(vMaxMonthName)"},PAYRL_AREA -= {00},EMPLGROUP -= {9}>}ANSALARY))*VCurrency_INR)/vUnitSelector,'#,##,###.##') "

now the expression which is to be bypassed instead of Employee_Code field is

"if(FinYear = vMaxFinYear and Year_Month_new = vMaxMonthName and  EMPLSTATUS = 3 and PAYRL_AREA <> 00 and EMPLGROUP <> 9 and Function_Text = GetFieldSelections(Function_Text), EMPLOYEE_Code) "

Regards,

Sumit

0 Replies