Variable in table causes long render times

Evan0211 — Wed, 16 Feb 2022 16:43:00 GMT

I am running into a strange issue with a pretty basic Qlik Sense table.

I have a column that has a dollar amount in it. I have a variable input loaded with buttons for All, >1M, >5M, >10M

The entire process works correctly, when you select the buttons, the table filters as intended, but it is slow.

The column is using the following Expression:

=Sum($($(vFilter))[Total Value])

This expresses correctly and the filtering happens, but it takes about 10-20 seconds to filter. If I were to hardcode in the filter:

=Sum({<[Total Value]={">1000000"}>}[Total Value])

Then there is no slowdown. Has anyone ever experienced this?

topic Variable in table causes long render times in App Development