Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
MMARG83
Contributor II
Contributor II

Field value Selection based on Two Expressions.

Dear Experts.

I have an expression written for a Field Value "[CASUAL WAGES]" as follows.

Sum({<DESCRIPTION={[CASUAL WAGES]}>}[DR AMT])

And there is another expression to get the [CASUAL WAGES ] calculation as follows,

(Sum({<DESCRIPTION={EPF 12%}>}[DR AMT])-Sum({<DESCRIPTIOM={GRATUITY}>}[DR AMT]))/12*100.

First expression need to select the Field value [CASUAL WAGES] in the Pivot Table and Second is needed to calculate the [CASUAL WAGES].

Is there a way to do both the selection and calculation in a singal expression.

Please help me to sort this out...

 

Labels (3)
1 Reply
Mark_Little
Luminary
Luminary

You will need to look at nest Set Analysis,

You first set analysis would become part of the second set expression.

Something like this

https://community.qlik.com/t5/New-to-Qlik-Sense/nested-set-analysis/td-p/1992619