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!

[Evan0211]

I just selected 1M and the expression at the bottom of the editor is:

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

[jwjackso]

Did you cut and paste the original filter from this discussion?  It looks like there is embedded html characters, <

You should be seeing 

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

It also looks like there is are square braces "[]" instead of a curly "{}" braces

[Evan0211]

Let me sanitize it real quick and see if that clears out the issue

[Evan0211]

I ran it through notepad and it still comes back with the #&lt; and &gt; encoding.  Any ideas?

[jwjackso]

I can't replicate the encoding, I can only suggest manually typing the string in the Qlik expression editor.

[Evan0211]

I just went back and hand typed it and it still shows the encoding.  

[Evan0211]

I spent most of the night trying to get this encoding issue cleared up and have run out of ideas.  I have created new variables, I have hand typed the expression, I have run it through notepad to strip anything out of it, I have even tried online encoding/decoding.  Nothing seems to work. No matter what, I have this as my expression:

=Sum({&lt;[Total Value]={"&gt;1000000"}&gt;}[Total Value])

The error says Error in expression: '}' expected

This is my dynamic value expression:

='~All|{<[Total Value]={">100000"}>}~>100k|{<[Total Value]={">500000"}>}~>500k|{<[Total Value]={">1000000"}>}~1M'

[jwjackso]

What browser and qlik sense version are you using?

[Evan0211]

I am using chrome.  I am unsure on the version, I am unfortunately just a cog in the wheel on this.  I don't own any of it.

[Evan0211]

Would there be any reason I would need an escape sequence with the quotes?