topic Re: Syntax error in my code in QlikView

Syntax error in my code

trishita — Tue, 22 May 2018 09:17:40 GMT

Can anybody point out what is wrong in my code?

if(Sounding Correction Status='Correction Done',

if(abs[Deviation after sounding]=abs[Difference Vs Log Survey],

green(), //When value of the both fields match they display green

if([Deviation after sounding] - [Difference Vs Log Survey]<>0,

yellow(), //When value of the both fields differ they display yellow

blue()

red() ////When Sounding Correction Status='Correction Not Done' they display red

Re: Syntax error in my code

jmvilaplanap — Tue, 22 May 2018 09:23:48 GMT

Hi,

You need to close the first if statement

if(Sounding Correction Status='Correction Done',

if(abs[Deviation after sounding]=abs[Difference Vs Log Survey],

green(), //When value of the both fields match they display green

if([Deviation after sounding] - [Difference Vs Log Survey]<>0,

yellow(), //When value of the both fields differ they display yellow

blue()

red() ////When Sounding Correction Status='Correction Not Done' they display red

)

Re: Syntax error in my code

fvelascog72 — Tue, 22 May 2018 09:25:28 GMT

Hi,

Maybe you have to close in braquets the field Sounding Correction Status. Like [Sounding Correction Status].

Saludos.

Re: Syntax error in my code

YoussefBelloum — Tue, 22 May 2018 09:25:59 GMT

Hi,

the field 'Sounding Correction Status' don't exist AND you can't create fields that contain spaces, without using" " or [ ]

like this:

[Sounding Correction Status]

"Sounding Correction Status"

Re: Syntax error in my code

Anonymous — Tue, 22 May 2018 09:28:39 GMT

Perhaps try the below, closing the statement and correcting where bold

if([Sounding Correction Status]='Correction Done',

if(abs[Deviation after sounding]=abs[Difference Vs Log Survey],

green(), //When value of the both fields match they display green

if([Deviation after sounding] - [Difference Vs Log Survey]<>0,

yellow(), //When value of the both fields differ they display yellow

blue()

red()

)

Re: Syntax error in my code

sasiparupudi1 — Tue, 22 May 2018 10:24:01 GMT

if([Sounding Correction Status]='Correction Done',

if(abs[Deviation after sounding]=abs([Difference Vs Log Survey]),

green(), //When value of the both fields match they display green

if(([Deviation after sounding] - [Difference Vs Log Survey])<>0,

yellow(), //When value of the both fields differ they display yellow

blue()

red()

Re: Syntax error in my code

trishita — Tue, 22 May 2018 10:39:14 GMT

Still having error:

if([Sounding Correction Status]='Correction Done',

if([Deviation after sounding]= [Summary.Difference Log vs Survey],

green(), //When value of the both fields match they display green

if([Deviation after sounding] - [Summary.Difference Log vs Survey]<>0,

yellow(), //When value of the both fields differ they display yellow

blue()
),
red()
)

Re: Syntax error in my code

m_woolf — Tue, 22 May 2018 10:44:02 GMT

You have three ifs but only two closing parentheses.

Re: Syntax error in my code

trishita — Tue, 22 May 2018 10:44:18 GMT

don't know still showing some error ..bracket problems I guess

Re: Syntax error in my code

m_woolf — Tue, 22 May 2018 10:56:06 GMT

if([Sounding Correction Status]='Correction Done',
     if([Deviation after sounding]= [Summary.Difference Log vs Survey],
          green(), //When value of the both fields match they display green
     if([Deviation after sounding] - [Summary.Difference Log vs Survey]<>0,
          yellow(), //When value of the both fields differ they display yellow
          blue()
     )),
red()
)

Re: Syntax error in my code

Re: Syntax error in my code

olivierrobin — Tue, 22 May 2018 12:08:12 GMT

hello

it is not abs put fabs()