topic Re: Grouping in QlikView

Script

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

Hi All,

I am trying to create a group by bucketing certain condition from 3 fields in the script , this reloads but dont show any output . My script is as below . Can someone please help me achiving this ?

Thanks in Advance.

Re: Grouping

avinashelite — Wed, 07 Oct 2020 06:55:04 GMT

Try like this

If(match(Dept,'A','X','Y','Z') , if(Match(Status,'Passed','Success','Processed'),'Scanned',
if(Match(Status,'Failed'),'Rejected','Total'))) as Category ,

Re: Grouping

smilingjohn — Wed, 07 Oct 2020 11:09:24 GMT

Hi Avinash this is not working

Re: Script

smilingjohn — Thu, 08 Oct 2020 20:30:44 GMT

Hi ALl,

This is my below script which i am trying to group this script reload but it dont show in output . is there way to habdle this witout making concatenation ?

Re: Grouping

smilingjohn — Wed, 07 Oct 2020 14:17:30 GMT

Hi Community any help on my post?

Re: Grouping

QFabian — Wed, 07 Oct 2020 15:06:16 GMT

hi, in this particular case, try with nested if, instead of separated if as i can see.

Re: Grouping

smilingjohn — Wed, 07 Oct 2020 15:42:13 GMT

Thanks for the reply @QFabian ,

Can you please provide me the example how do i use nested if in this perticular issue ?

Thanks

Re: Grouping

QFabian — Wed, 07 Oct 2020 15:49:37 GMT

did you check the atached image in my previous reply?

Basically, as i can see, you do an if, then another, but you should do as follow :

if( A=1, action1, if (A=2, action2, if(....... and so on.

Re: Grouping

smilingjohn — Wed, 07 Oct 2020 16:13:15 GMT

I saw you image but i dont understand what are you trying to say .

Thanks

Re: Grouping

QFabian — Wed, 07 Oct 2020 18:50:56 GMT

Checking again, you already have nested if, so, i think you should probably create each wilmatch statement as a separate field, just for seeing if the values are ok for the total ifs workflow validations.

example :

Re: Grouping

smilingjohn — Thu, 08 Oct 2020 12:50:12 GMT

Hi Expertise ,

Cant i make this in a single script the way i have shared above screenshot ?

After loading the script there is no output for this