How to get value of expression in Pivot Table

dotnetfan — Sat, 16 Nov 2024 03:07:22 GMT

Hello,

I have 4 data filters, name from M+0 to M+3, for each filter it has one column with three values, 1,2,3. There is a variable which allow user to change manually in the report, if user changed the variable then the value in the pivot value need to change accordingly:

If I use following expression, then I can get the correct expression for each column:

='GetFieldSelections([M+'&"=If(Left(LT.Month,4) = 2019, Right(LT.Month,2) + 0, Right(LT.Month,2) + 12) - '$(CurrentMonth)'"&'.Val])',

I would like to get the value for this expression, please kindly help me know how to do it.

Thanks,

Re: How to get value of expression in Pivot Table

Lauri — Tue, 03 Mar 2020 15:45:59 GMT

I'm not sure I understand what you want to do. If you want the expression to show a result, use dollar sign expansion to calculate the If statement, and also to get the value of CurrentMonth:

=GetFieldSelections([M$(=If(Left(LT.Month,4) = 2019, Right(LT.Month,2) + 0, Right(LT.Month,2) + 12)) - $(=CurrentMonth).Val])

There may be an error in this, because I don't have those fields in a Qlik app, so I can't test it properly. Let me know if it works.

topic How to get value of expression in Pivot Table in App Development

How to get value of expression in Pivot Table

Re: How to get value of expression in Pivot Table