Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
I just selected 1M and the expression at the bottom of the editor is:
=Sum({<[Total Value]=[">1000000"}>][Total Value])
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
Let me sanitize it real quick and see if that clears out the issue
I ran it through notepad and it still comes back with the #< and > encoding. Any ideas?
I can't replicate the encoding, I can only suggest manually typing the string in the Qlik expression editor.
I just went back and hand typed it and it still shows the encoding.
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({<[Total Value]={">1000000"}>}[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'
What browser and qlik sense version are you using?
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.
Would there be any reason I would need an escape sequence with the quotes?