topic Create two conditions in the "Edit Script " in QlikView

Create two conditions in the "Edit Script "

Wed, 01 Jun 2011 12:04:05 GMT

Create two conditions in the "Edit Script " QlikView, example:

I created one that has only one condition and it worked right

IF (NUM ([COD. COMPANY]) = 11, 'COMPANY 1 '
IF (NUM ([COD. COMPANY]) = 14, 'COMPANY 2'
IF (NUM ([COD. COMPANY]) = 18 'COMPANY 3 ',))) AS WORK

BRANCH

I wanted one with two conditions that would look like this phenomenon, is cod. company = 11 and cod.branch = 517 then COMPANY 517

if anyone can help me.

thanks

Create two conditions in the "Edit Script "

kji — Wed, 01 Jun 2011 12:09:34 GMT

Looks to me like you need a comma at the end of the first 2 lines, and a value for when COD. COMPANY is not 11,14 or 18

Create two conditions in the "Edit Script "

Wed, 01 Jun 2011 12:10:51 GMT

Try this:

IF (NUM ([COD. COMPANY]) = 11, 'COMPANY 1 '

IF (NUM ([COD. COMPANY]) = 14, 'COMPANY 2'

IF (NUM ([COD. COMPANY]) = 18 'COMPANY 3 ',

if(NUM ([COD. COMPANY]) = 11 and num(cod.branch) = 517 , 'COMPANY 517'

))) ) AS WORK

Re: Create two conditions in the "Edit Script "

Miguel_Angel_Baeyens — Wed, 01 Jun 2011 12:14:27 GMT

Hello,

This syntax should work

If(Num([COD. COMPANY]) = 11 AND BRANCH = 517, 
     517, // When condition is true
     If(Num([COD. COMPANY]) = 11 AND BRANCH = 518, // When condition is false, nest a new If()
          518,
          'Other')
) AS COMPANY

Anyway, depending on your data model there might be some easier solution, probably using mapping tables, joins and so. Having complex conditionals may perform really poor and it make the script to take longer to load.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Create two conditions in the "Edit Script "

Wed, 01 Jun 2011 12:17:13 GMT

Hello Johan, I need two conditions even

Create two conditions in the "Edit Script "

Wed, 01 Jun 2011 13:14:45 GMT

Thanks to all who somehow tried to help me, it worked just fine Miguel.