Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
when I put the variable v_DIVISION in a text object I have this: VSDACHBENSCAN
when is use this on a textbox: if(wildmatch(concat([Company code],','),'*NL*'),'NL','NOT NL') I have NL on my textbox
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 ?
Try this
=Aggr(If(v_DIVISION = 'VSDACHBENSCAN' and WildMatch(Concat([Company code], ','), '*NL*') and Match(Division_customer, 'D09'), CustomersC), CustomersC)
May be try this
=If($(v_DIVISION) = 'VSDACHBENSCAN' and WildMatch(Concat([Company code], ','), '*NL*') and Match(Division_customer, 'D09'), CustomersC)
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
Try this
=Aggr(If(v_DIVISION = 'VSDACHBENSCAN' and WildMatch(Concat([Company code], ','), '*NL*') and Match(Division_customer, 'D09'), CustomersC), CustomersC)
It is working..
can you explain this ?
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
PAY HIM ! PAY HIIM !!
no points for today
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().... ??
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)
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