topic Re: Line Script in QlikView

Line Script

pgalvezt — Thu, 02 Aug 2012 18:16:20 GMT

Hi, I have different phases in my formulas. but this particular is not running.

if((sum(Date)>=181 And sum(Date)<=210) Or num(Field1) <> 8,Dual('Phase7',8)

Thanks

Re: Line Script

Thu, 02 Aug 2012 18:27:53 GMT

Can you please try ths

if((sum(Date)>=181 And sum(Date)<=210),If( num(Field1) <> 8,Dual('Phase7',8)))

Re: Line Script

ericcosmai — Thu, 02 Aug 2012 18:31:36 GMT

Hi.

Looking to this formula... is without a parentheses at the end.

Hope it helps.

Regards.

Re: Line Script

pgalvezt — Thu, 02 Aug 2012 18:39:17 GMT

Is not working.

I tried change it for this: but still not working.

((sum(Date)>=181 And sum(Date)<=210) And Field1 = 'V',Dual('181-210 Días',8)

Thanks

Re: Line Script

ericcosmai — Thu, 02 Aug 2012 18:48:28 GMT

Can you send any sample application... Only looking... it seems strange... because have this field called Date... I'm not sure if you can make a Sum() on this field without a treatment...

Regards..

Re: Line Script

pgalvezt — Thu, 02 Aug 2012 18:57:31 GMT

Date is formated like num. Dont worry for that date because in the other lines works fine. I think the problem is in Or -And.

Re: Line Script

ericcosmai — Thu, 02 Aug 2012 19:23:29 GMT

I think you can try put the else sentence like a null value... like this: '<empty>'

Look if it solves:

if((sum(Date)>=181 And sum(Date)<=210) And Field1 = 'V',
Dual('181-210 Días',8)
,
''
)

Hope it works. Regards.

Re: Line Script

ericcosmai — Thu, 02 Aug 2012 20:16:38 GMT

So?

It works?

Regards.

Re: Line Script

chematos — Thu, 02 Aug 2012 20:35:59 GMT

(

sum(Date)>=181 And sum(Date)<=210

)

And Field1 = 'V',

Dual('181-210 Días',8)

)