topic Re: How to do filter after filtering in the expression? in QlikView

How to do filter after filtering in the expression?

bhaveshp90 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a table with Region, Report_Parameters as the dimension and the expression is given below;

(

Report_Param = 'Gross Profit in % of Sales',

((Sum({< Report_Param = {'Gross Profit'}>}Value))

(Sum({< Report_Param = {'Sales'}>}Value))),

Sum(Value)

)

Logic: For all the Report Parameters the Values = Sum(Values) except for Gross Profit in % of Sales.

For Gross Profit in % of Sales, the value is Sum(Gross Profit)/Sum(Sales)

But the Report Parameter = "Gross Profit in % of Sales" is filtering out from my table as shown below;

What wrong am I doing here?

thanks

Bhavesh

sunny_talwar — Thu, 18 Oct 2018 14:52:54 GMT

Try this

If(Report_Param = 'Gross Profit in % of Sales',

((Sum(TOTAL <MonthField, BudgetForcastField> {< Report_Param = {'Gross Profit'}>}Value))

(Sum(TOTAL <MonthField, BudgetForcastField> {< Report_Param = {'Sales'}>}Value))),

Sum(Value)

)

Where MonthField and BudgetForcastField are the fields from your chart

bhaveshp90 — Thu, 18 Oct 2018 18:50:43 GMT

Wow, it worked just like that. thank you Sunny for the solution