Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sanp96
Contributor II
Contributor II

Creating filter

Hello all,

I have a question with respect to creating filters for a table chart. I had asked a question for the same table chart visualization previously. I am attaching the chart again. It has many other columns along with this one.

Type   
dhdg discount   
arf policy   
abc discount   
xyz policy   
pqr discount   
xyz policy   
efg policy   

 

Is it possible to create a filter that will have only 2 values as 'Policy' and 'Discount' based on the 'Type' column, but it should display all the rows containing the respective text?

To elaborate, say the filter is set to 'Policy', then I want the result to be like:

Type   
arf policy   
xyz policy   
xyz policy   
efg policy   

 

Any help with this is highly appreciated.

Thanks!

Labels (5)
1 Solution

Accepted Solutions
arulsettu
Master III
Master III

Maybe like this you can create a new column in load script

pick(wildmatch(Type,'*policy*','*discount*'),'Policy','Discount') as New_Type

View solution in original post

2 Replies
arulsettu
Master III
Master III

Maybe like this you can create a new column in load script

pick(wildmatch(Type,'*policy*','*discount*'),'Policy','Discount') as New_Type

View solution in original post

sanp96
Contributor II
Contributor II
Author

I created a dimension using this logic and it worked. Thanks a lot!