topic Re: Nested if Script Syntax in QlikView

Nested if Script Syntax

Wed, 23 Oct 2013 19:43:36 GMT

hi i would like to run the following script in the backend.

my purpose is to merge the two statements into one field. However my syntax seems to be wrong.

both statements work perfectly fine by themselves.

Any help would be greatly appreciated.

if(len(trim(Orderkund))=9 and isnum(left(trim(Orderkund),4)) and isnum(right(trim(Orderkund),4)),left(Orderkund,4) & '-0000'

"Giltig_flagga" = 0, (left("Text 1",9))) as EndCustomer

Re: Nested if Script Syntax

Clever_Anjos — Wed, 23 Oct 2013 19:46:46 GMT

I don´t see how "Giltig_flagga" = 0 can be true, you´re comparing a string to 0, is that?

Re: Nested if Script Syntax

Wed, 23 Oct 2013 19:54:26 GMT

it is a flag that by default is 0, or Null.

Re: Nested if Script Syntax

Clever_Anjos — Wed, 23 Oct 2013 19:58:13 GMT

=if(len(trim(Orderkund))=9 and isnum(left(trim(Orderkund),4)) and isnum(right(trim(Orderkund),4)),left(Orderkund,4) & '-0000' or Giltig_flagga = 0, (left('Text 1',9)))

Works here, note that I´m using single quote at 'Text 1' and no quotes at Giltig_flagga