Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using set analysi in which i need to include the string which has "1-Blcok search" but the problem is there are many places where this is in the middle and some time it is after one word
how do i deal with this kind of situation .
As shown in below "1-Blcok search" some times it is only that , and in the end row it is in the middle and some time is in the last .
1-Blcok search
Build 1-Blcok search
Cosmatics 1-Blcok search Build
How do in include such thing in set analysis ?
Thanks in Advance
maybe use the "or" operator like this:
=sum({<Name={"=Wildmatch(Name,'*1-Blcok search*')=1 or Wildmatch(Name,'*H1-Blood*')=1"}>}Data)
Try like
Load If(Match(FieldName, '1-Blcok search'), 1,0) as Flag From Table;
Then in analysis use an ex, Sum({<Flag={1}>} Sales)
try like this:
=sum({<Name={"=Wildmatch(Name,'*1-Blcok search*')=1"}>}Data)
Thanks for the reply Frank.
This is working for one search , when i add many search within this is is not working
=sum({<Name={"=Wildmatch(Name,'*1-Blcok search*','*2-Cosmatics*','*H1-Blood'*)=1"}>}Data)
Do I need to make changes to set analysis ?
Thanks
maybe use the "or" operator like this:
=sum({<Name={"=Wildmatch(Name,'*1-Blcok search*')=1 or Wildmatch(Name,'*H1-Blood*')=1"}>}Data)
Just add and correct:
=sum({<Name={"=Wildmatch(Name,'*1-Blcok search*','*2-Cosmatics*','*H1-Blood*')>=1"}>}Data)
whereby the wildmatch isn't really needed else it should also work with:
=sum({<Name={'*1-Blcok search*','*2-Cosmatics*','*H1-Blood*'}>}Data)
- Marcus
Hi John,
Why can't you create flag in script level and make it easy in expreesion level.
thank you
Regards,
Nagarjun
Thanks Frank
This is working , To exclude this can i use the below expression I doubt this .
sum({<Name-={"=Wildmatch(Name,'*1-Blcok search*') or Wildmatch(Name,'*H1-Blood*')=1"}>}Data)
Thanks