topic Re: Nested if don't work in QlikView

Nested if don't work

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

Hi Community,

I have a problem on this: (listbox)

=if(v_DIVISION='VSDACHBENSCAN' and wildmatch(concat([Company code],','),'*NL*'),

if(match(Division_customer,'D09'),CustomersC))

as you can see, nested if, but resulting to nothing..

the problem is that when I use these 3 conditions separetely, they works as expected:

v_DIVISION is declared on the script and the output is : VSDACHBENSCAN

when I put the variable v_DIVISION in a text object I have this: VSDACHBENSCAN

[Company code] give 'NL10' and 'NL11', that's why I used wildmatch(concat([Company code],','),'*NL*')

when is use this on a textbox: if(wildmatch(concat([Company code],','),'*NL*'),'NL','NOT NL') I have NL on my textbox

For Division_customer, I have a list of Customers = D09 and a list = D07

when I use this on a listbox, if(match(Division_customer,'D09'),CustomersC) I have the right list of D09 customers.

Why combined together, these conditions don't work ?

Re: Nested if don't work

sunny_talwar — Thu, 01 Mar 2018 13:35:19 GMT

May be try this

=If($(v_DIVISION) = 'VSDACHBENSCAN' and WildMatch(Concat([Company code], ','), '*NL*') and Match(Division_customer, 'D09'), CustomersC)

Re: Nested if don't work

YoussefBelloum — Thu, 01 Mar 2018 13:39:58 GMT

My variable is declared like this:

LET v_DIVISION=replace(mid(DocumentName(),index(DocumentName(),'-')+2),'.qvw','');

so I call it without $ to have my result.

and I already tried to use AND instead of the second IF.. it is the same.. it shows nothing

Re: Nested if don't work

sunny_talwar — Thu, 01 Mar 2018 13:43:05 GMT

Try this

=Aggr(If(v_DIVISION = 'VSDACHBENSCAN' and WildMatch(Concat([Company code], ','), '*NL*') and Match(Division_customer, 'D09'), CustomersC), CustomersC)

Re: Nested if don't work

YoussefBelloum — Thu, 01 Mar 2018 13:44:39 GMT

It is working..

can you explain this ?

Re: Nested if don't work

sunny_talwar — Thu, 01 Mar 2018 13:46:32 GMT

Since you had Concat() in your expression, this was probably error-ing out... Either you need to have TOTAL qualifier (which to me did not make sense), you needed to add a dimension

Re: Nested if don't work

YoussefBelloum — Thu, 01 Mar 2018 13:48:09 GMT

PAY HIM ! PAY HIIM !!

no points for today

Re: Nested if don't work

YoussefBelloum — Thu, 01 Mar 2018 13:53:53 GMT

Thank you for this.

Since Company code is related to section access and users don't need to use it because data is already reduced to it and since I need to make a test on NL value without having my field selected..

do you have an alternative to this:

WildMatch(Concat([Company code], ','), '*NL*')

to detect if I have NL values on that field without using concat and avoid Aggr().... ??

Re: Nested if don't work

sunny_talwar — Thu, 01 Mar 2018 13:57:50 GMT

So, you don't want to show selection in Company code, right? May be try this....

=Aggr(Only({<CustomersC = {"=v_DIVISION = 'VSDACHBENSCAN' and WildMatch(Concat([Company code], ','), '*NL*') and Match(Division_customer, 'D09')"}>} CustomersC), CustomersC)

Re: Nested if don't work

YoussefBelloum — Thu, 01 Mar 2018 14:04:35 GMT

No, sorry,

I mean that I want to detect if on the field "Company code", I have "NL" values, without doing selections on NL (on that field) and without using wildmatch concat.. I want to know if there is an alternative to Wildmatch concat

Re: Nested if don't work

sunny_talwar — Thu, 01 Mar 2018 16:45:17 GMT

without doing selections on NL (on that field)

This will work with the above expression....Only CustomersC will be selected and nothing else

without using wildmatch concat..

Why do you not want to use WildMatch, that will help me understand what you are trying to do and may be I can suggest an alternative

Re: Nested if don't work

YoussefBelloum — Thu, 01 Mar 2018 16:57:31 GMT

EDITED

Ok,

on an app, we have a field called A with the following values (A1, A2, A3, A4, A5)

my section access reduces the values to (A1, A2, A3)

after opening the application., my possible values on the field A are: (A1, A2, A3)

without selecting anything, with this expression:

Wildmatch (concat (A, '*2*')

I can tell if I have a value that includes the number '2' in my possible values on the field A.

is there another technique that returns me TRUE for this test? PS: without making selections on the field A

I ask this question because first, I do not want to complicate the expression with AGGR (), since you told me that with CONCAT I have to use AGGR () and second, It is always interesting to learn something new

Thank you

Re: Nested if don't work

sunny_talwar — Thu, 01 Mar 2018 18:54:55 GMT

Within set analysis it is possible using p() function... but if you want to use the if statement, I am afraid Concat might be the only option

Re: Nested if don't work

YoussefBelloum — Thu, 01 Mar 2018 21:55:27 GMT

Thanks again bro,

I'll try to do it.

Now I know there are two ways to do this.