Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try going thru wildmatch() function.
Hope this helps
Thanks
I have tried if(WildMatch([Item Type],'*HOME*'),sum([Price])), but its not working can someone help?
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
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
Hi
Try this
if(WildMatch([Item Type],'HOME*'),sum([Price]))
Thanks
sorry, still not working
Hi
Please attach some sample file so that anyone can try it out
Thanks