topic variables in sum filter not working in QlikView

variables in sum filter not working

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

Hi All,

I cant seem to get the range selection right when i replace values with variables in a sum({}value) expression.

I've attached a example. The "Sales - Range" needs tweaking to work similar to "Sales - Values" with the difference of being dynamic.

trdandamudi — Fri, 13 May 2016 13:52:28 GMT

May be as below:

=SUM({<RowNumber={">=$('lLimit')<=$('uLimit')"}>}Sales)

sunny_talwar — Fri, 13 May 2016 13:53:51 GMT

Try this:

=Sum({<RowNumber={"$(='>=' & $(lLimit) & '<=' & $(uLimit))"}>}Sales)

anagharao — Thu, 19 May 2016 03:36:14 GMT

Thank you !!