Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
Gartner® Magic Quadrant™: 15 YEARS A LEADER - GET THE REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
marcobis
Contributor II
Contributor II

Button to filter values

Hi all, I have this table with a dimension called 'Ragione Sociale' and I want to create a button to filter and exclude values starting with  '***', but * is a wildcard; how can this be achieved?

 

Cattura.PNG

Labels (4)
1 Solution

Accepted Solutions
justISO
Specialist
Specialist

Hi, instead of wildcard maybe use left() or index(), like:

if(left([Regione Sociale], 3)='***' , 1,0)...

View solution in original post

1 Reply
justISO
Specialist
Specialist

Hi, instead of wildcard maybe use left() or index(), like:

if(left([Regione Sociale], 3)='***' , 1,0)...