Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Check if text contain specific words (Calculated Dimension)

Dear Qlikview Experts,

What is the correct syntax for calculated dimension to check if a text contain specific words? I wanted to create a bar chart with data

looks like below, I have used 'Type' as my first dimension, follow with a calculated dimension and my expression is :Value.

I want to modify my calculated dimension such that when 'Product' = Equipment / (Any text contains 'Pen' )

My calculated dimension is: "=if(Match(Product ,'Equipment','*Pen*'), Product) "   But it does not work

(It works if I key in full text, but I need to deal with a large amount of text in future and most of them contains 'Pen')

I had also attached a sample of testing qvw for your reference. Thank you for your help in advance!

1.PNG

Capture2.PNG

Best Regards

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Check if text contain specific words (Calculated Dimension)

Hi Zhang,

Try this, May b it will work

=if(WildMatch(Product ,'Equipment','*Pen*'), Product)


Regards,

Jayshri

View solution in original post

7 Replies
Highlighted
Contributor III
Contributor III

Re: Check if text contain specific words (Calculated Dimension)

I tried it with a classic SetAnalysis

Highlighted
Partner
Partner

Re: Check if text contain specific words (Calculated Dimension)

Hi Zhang,

Try this, May b it will work

=if(WildMatch(Product ,'Equipment','*Pen*'), Product)


Regards,

Jayshri

View solution in original post

Highlighted
Master
Master

Re: Check if text contain specific words (Calculated Dimension)

Can you try with wild match?

Highlighted
Master
Master

Re: Check if text contain specific words (Calculated Dimension)

if(WildMatch(Product ,'Equipment','*Pen*'), Product)

Highlighted
Creator III
Creator III

Re: Check if text contain specific words (Calculated Dimension)

Dear Jayshri,

It works like a charm! Thank you so much!

Best Regards

QianNing

Highlighted
Creator III
Creator III

Re: Check if text contain specific words (Calculated Dimension)

Dear Shivesh,

It works! Thank you!

Best Regards

QianNing

Highlighted
Partner
Partner

Re: Check if text contain specific words (Calculated Dimension)

Welcome QianNing