Using Expression in Filter Pane

[ExQlikDW]

I used to be able to do something like this, e.g. under Filter pane of Customer dimension, I can type =SUM(Sales)>100,000 to have qlik return a list of all customers who have purchased greater than 100,000.  Now, it seems like this good feature no longer supported.  Am I right?  or there is some hidden configuration that I need to turn on somewhere?

[rubenmarin · Accepted solution]

Hi, I just tested it on cloud version and it still works, I didn't noticed it has stopped working. Have you checked that the expression you are trying retuns true for any of the values? You can also try in a table, adding the dimension and the expression used as filter like "If([Expression], 1, 0)", sort descendent and check if it returns any '1'

[Lech_Miszkiewicz · Accepted solution]

Hi @ExQlikDW 

There is no change - advanced search still works as expected. I hope you didnt use coma in your search (100,000). It should be just =SUM(Sales)>100000

[ExQlikDW]

Thank guys for the confirmation.  I must have typed the measure name wrong (upper case, lower case) . That's a relief because this is a cool feature just like that double click a master item, it will be automatically added to a chart, but the later functionality apparently has been retired.  I thought Qlik is taking away this feature too.   Glad they didnt.