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!