Creating a threshold filter for a table

[Evan0211]

I have a table that has a field on it with dollar amounts.  I would like to create a threshold filter of pre-defined values (All, 100k, 500k, 1M, etc) and when the user selects the amount, the table will filter to the items that are >= the threshold.  I cannot find any charts or controls that will do this.  I do not have the ability to install any extensions due to restrictions from the data owner.

Thanks!

[jwjackso]

I think you should create a new straight table with a dimension and several measures just to verify that the measures are working as expected.  If the $(vFilter) measure is the only problem, change the variable input expression to only 2 options and test again.

measure1 = Sum([Total Value])

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

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

[Evan0211]

Measure 1 works

Measure 2 works

Measure 3 does not.  Same issue as before, it is encoding the < and > to &lt; and &gt;

[jwjackso]

Where is the vFilter variable created, in my tests I added it to the load script as 

Set vFilter="";

[Evan0211]

I used the variable interface to create it. 

Edit: I went in the load script and added a new variable but same result with the new variable name.

[Evan0211]

I got word that we are on Qlik Sense Enterprise if that helps. 

[jwjackso]

Does measure3 fail even when you select the All variable which should be empty and return the same value as measure1?

[Evan0211 · Accepted solution]

After trial and error, I found out that this is a known error (https://community.qlik.com/t5/New-to-Qlik-Sense/Variable-Input-extension-Dashboard-Bundle-stopped-wo...)

What I had to do to get it working was set each of my thresholds as their own individual variables and then include the variable name in the dynamic values string.  

In the table column expression, I had to add =Sum($($(vFilter))[Total Value]) to get it to work correctly.  Thanks for all of the help, I really appreciate it.