Check if text contain specific words (Calculated Dimension)

[s10157754]

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!

Best Regards

[kruppas78]

I tried it with a classic SetAnalysis

[jayshrinipurte · Accepted solution]

Hi Zhang,

Try this, May b it will work

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

Regards,

Jayshri

[shiveshsingh]

Can you try with wild match?

[shiveshsingh]

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

[s10157754]

Dear Jayshri,

It works like a charm! Thank you so much!

Best Regards

QianNing

[s10157754]

Dear Shivesh,

It works! Thank you!

Best Regards

QianNing

[jayshrinipurte]

Welcome QianNing