topic Re: Set Analysis in QlikView

Set Analysis

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

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

Re: Set Analysis

Anil_Babu_Samineni — Thu, 09 Jan 2020 08:03:20 GMT

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)

Re: Set Analysis

Frank_Hartmann — Thu, 09 Jan 2020 08:07:23 GMT

try like this:

=sum({<Name={"=Wildmatch(Name,'*1-Blcok search*')=1"}>}Data)

Re: Set Analysis

smilingjohn — Thu, 09 Jan 2020 09:04:54 GMT

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

Re: Set Analysis

Frank_Hartmann — Thu, 09 Jan 2020 09:15:41 GMT

maybe use the "or" operator like this:

=sum({<Name={"=Wildmatch(Name,'*1-Blcok search*')=1 or Wildmatch(Name,'*H1-Blood*')=1"}>}Data)

Re: Set Analysis

marcus_sommer — Thu, 09 Jan 2020 09:18:52 GMT

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

Re: Set Analysis

Nagarjun_km — Thu, 09 Jan 2020 09:26:47 GMT

Hi John,

Why can't you create flag in script level and make it easy in expreesion level.

thank you

Regards,

Nagarjun

Re: Set Analysis

smilingjohn — Thu, 09 Jan 2020 09:47:03 GMT

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