How to match first 4 words with a variable and show the result

[rolasyeow]

Hi, I wanted to see all the information for a specific item only, below is an example

HOME 12345

HOME 23145

HOME 242

LIME 231

LIME 232141

HOME 231245

LIMOS 2312412

What I wanted is, the information shown is all related to HOME only. How do I do that? I mean I want to match HOME with my variable which is called [Item Type], if matched then show all the results related to HOME item type

[Kashyap_R]

Hi

Try going thru wildmatch() function.

Hope this helps

Thanks

[rolasyeow]

I have tried if(WildMatch([Item Type],'*HOME*'),sum([Price])), but its not working can someone help?

[Kashyap_R]

Hi

Can u attach a sample qvf and describe what is ur requirement like in a table or in which visualization the output you want?

Thanks

[rolasyeow]

its like if the first 4 character is "HOME", then every item name start with "HOME" will have the price shown, which basically means the other item's name not starting with "HOME" will not have it's price shown in this measure

[Kashyap_R]

Hi

Try this

if(WildMatch([Item Type],'HOME*'),sum([Price]))

Thanks

[rolasyeow]

sorry, still not working

[Kashyap_R]

Hi

Please attach some sample file so that anyone can try it out

Thanks