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

Check if text contain specific words (Calculated Dimension)

s10157754 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 17 May 2018 07:26:04 GMT

I tried it with a classic SetAnalysis

jayshrinipurte — Thu, 17 May 2018 07:30:14 GMT

Hi Zhang,

Try this, May b it will work

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

Regards,

Jayshri

shiveshsingh — Thu, 17 May 2018 07:36:31 GMT

Can you try with wild match?

shiveshsingh — Thu, 17 May 2018 07:43:01 GMT

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

s10157754 — Thu, 17 May 2018 08:25:24 GMT

Dear Jayshri,

It works like a charm! Thank you so much!

Best Regards

QianNing

s10157754 — Thu, 17 May 2018 08:25:59 GMT

Dear Shivesh,

It works! Thank you!

Best Regards

QianNing

jayshrinipurte — Thu, 17 May 2018 08:26:56 GMT

Welcome QianNing