topic Re: Group in QlikView

Group

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

Hi All,

I am trying to create a group in the script , and this gets executed in the output i don't see GR1 and GR2 .

how do i get this ?

if(WildMatch(goup,'host'),'host',

if(WildMatch(goup,'payments'),'payments',

if(WildMatch(goup,'roles'),'roles',

if(WildMatch(goup,'hr'),'hr',

if(WildMatch(goup,'dudes'),'dudes',

if(WildMatch(goup,'check'),'check',

if(WildMatch(goup,'pass'),'pass',

if(WildMatch(goup,'pass','dudes','check'),'GR1',

if(WildMatch(goup,'pass','host','hr'),'GR2'

)))))))))as Create_Group

Thanks in Advance

Re: Group

ariel_klien — Mon, 23 Sep 2019 11:06:20 GMT

Hi, Because the if ended before he get to GR1\2 You can make another field for GR1 and another to GR2 OR you can load the same code for only GR1 and only GR2 and concatenate the 3 tables. Ariel.

Re: Group

smilingjohn — Mon, 23 Sep 2019 12:22:54 GMT

Is there no way to achieve this within one group?

Re: Group

martinpohl — Mon, 23 Sep 2019 12:32:17 GMT

hi,

how should it work to set the datas into one group.

Either if statement one is right, so you get result one or the if-statement for GR is right so you get result two.

An if-statement quits if the first result is true.

Regards

Re: Group

ariel_klien — Mon, 23 Sep 2019 13:38:13 GMT

Hi,

you can do something like this:

MainTable:
load * From ...;

Groups:
Load goup,
if(WildMatch(goup,'host'),'host',
if(WildMatch(goup,'payments'),'payments',
if(WildMatch(goup,'roles'),'roles',
if(WildMatch(goup,'hr'),'hr',
if(WildMatch(goup,'dudes'),'dudes',
if(WildMatch(goup,'check'),'check',
if(WildMatch(goup,'pass'),'pass'))))))) as Create_Group
resident Main Table;

Concatenate (Groups)
load goup,
'GR1' as Create_Group
resident MainTable
where WildMatch(goup,'pass','dudes','check');

Concatenate (Groups)
load distinct goup,
'GR2' as Create_Group
resident MainTable
Where WildMatch(goup,'pass','host','hr')

Re: Group

Brett_Bleess — Wed, 02 Oct 2019 14:29:00 GMT

Did Ariel's last post work for you? If so, be sure to use the Accept as Solution button on that post to give him credit for the help and let others know that worked. If you did something different, consider posting that and mark that as the solution and if you are still working on things, leave an update for us.

Regards,
Brett

Re: Group

rwunderlich — Wed, 02 Oct 2019 19:06:15 GMT

Your GR1 condition is true if goup = 'pass' OR 'dudes'. However, that condition would have been met in the earlier if() and therefore the GR1 if() is not executed.

If you are trying to create a one-to-many relationship where one goup links to many Create_Group, you should load a separate table like this:

Groups:
LOAD * INLINE [
goup, Create_Group
host, host
payments, payments
dudes, dudes
pass, pass
pass, GR1
dudes, GR1
etc
];

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com