Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
ExQlikDW
Contributor II
Contributor II

Using Expression in Filter Pane

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?

 

 

Labels (2)
2 Replies
rubenmarin

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Lech_Miszkiewicz_0-1765441984075.png

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.