Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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