Field value Selection based on Two Expressions.

[MMARG83]

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...

[Mark_Little]

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