topic Re: Error in expression : ')' expected in QlikView

Error in expression : ')' expected

Fri, 17 Jun 2016 09:24:50 GMT

Hi does anyone know what I did wrong ?

if($(xxx),'130',

if($(xxx),'140',

if($(xxx),'20',

if($(xxx),'30',

if($(xxx),'0','100')))))

Anthony

Re: Error in expression : ')' expected

oknotsen — Fri, 17 Jun 2016 09:40:35 GMT

Could you please show us the content of "xxx" and the code surrounding this piece of code? My guess is the error is caused in any of those two.

Re: Error in expression : ')' expected

sunny_talwar — Fri, 17 Jun 2016 09:40:49 GMT

What is $(xxx) here? Variable>

Re: Error in expression : ')' expected

sasikanth — Fri, 17 Jun 2016 09:41:10 GMT

Is this your expression ? can you give some more inputs..

Re: Error in expression : ')' expected

Kushal_Chawda — Fri, 17 Jun 2016 09:44:54 GMT

try with single quotes

if('$(xxx)','130',

if('$(xxx)','140',

if('$(xxx)','20',

if('$(xxx)','30',

if('$(xxx)','0','100')))))

Re: Error in expression : ')' expected

Fri, 17 Jun 2016 09:46:49 GMT

if($(TickXOIP),'130',

if($(TickInternational),'140',

if($(fils),'20',

if($(NBDGPM),'30',

if($(ClosStream),'100'))))))

Yes they are variable

Re: Error in expression : ')' expected

Anonymous — Fri, 17 Jun 2016 09:50:00 GMT

Hi Anthony,

If you have any comments, or your expression returns strings or formated dates, QlikView will return errors. We need to see the content of your var.

Regards!

Re: Error in expression : ')' expected

oknotsen — Fri, 17 Jun 2016 09:50:54 GMT

Could you should us the content of those variables? My guess is some of them have expressions in them and maybe one of those is missing a bracket.

Re: Error in expression : ')' expected

migueldelval — Fri, 17 Jun 2016 09:51:20 GMT

Hi Anthony Pardo,

Your expression it´s ok (you can see it in attach picture). The problem its your expression $(XXX). If it´s a variable, check this document: The Magic of Variables

Regards

Miguel del Valle de Gracia

Re: Error in expression : ')' expected

Fri, 17 Jun 2016 09:52:37 GMT

not working I also tried

if('$(=xxx)','130',

if('$(=xxx)','140',

if('$(=xxx)','20',

if('$(=xxx)','30',

if('$(=xxx)','0','100')))))
and

if($(=xxx),'130',

if($(=xxx),'140',

if($(=xxx),'20',

if($(=xxx),'30',

if($(=xxx),'0','100')))))

Re: Error in expression : ')' expected

elakkians — Fri, 17 Jun 2016 09:59:05 GMT

Hi ,

Is the variable created correctly . check in variable overview whether it is created or not .

Re: Error in expression : ')' expected

sasiparupudi1 — Fri, 17 Jun 2016 10:04:36 GMT

Try like this as you need to check for the value of the variable..If it returns a -1

=if($(TickXOIP)=-1,'130',

if($(TickInternational)=-1,'140',

if($(fils)=-1,'20',

if($(NBDGPM)=-1,'30',

if($(ClosStream)=-1,'100')))))

Re: Error in expression : ')' expected

sasikanth — Fri, 17 Jun 2016 10:07:17 GMT

Hi,

Check the variable expressions, u might not closed this bracket ')'

Re: Error in expression : ')' expected

nizamsha — Fri, 17 Jun 2016 10:10:28 GMT

$(XXX) is a variable right try to put single quotes and check

if('$(xxx)','130',

if('$(xxx)','140',

if('$(xxx)','20',

if('$(xxx)','30',

if('$(xxx)','0','100')))))

if('$(TickXOIP)'='130','130',

if('$(TickInternational)'='140','140',

if('$(fils)'='20','20',

if('$(NBDGPM)'='30','30',

if('$(ClosStream)'='100','100'))))))

Re: Error in expression : ')' expected

Fri, 17 Jun 2016 10:12:17 GMT

try like this

if('$(TickXOIP)','130',

if('$(TickInternational)','140',

if('$(fils)','20',

if('$(NBDGPM)','30',

if('$(ClosStream)','100'))))))

Re: Error in expression : ')' expected

Fri, 17 Jun 2016 13:17:06 GMT

Now I'm just trying to do that

if($(TickXOIP),'130%',

if($(TickInternational),'140%','other')

TickXOIP=($(ISUSCPilote) + $(ActivesISTOIP) + $(BTIPBTIC))

ISUSCPilote=count({<IXOIPIS={1}>} distinct PHT_IDTTIC)

ActivesISTOIP=sum(ISTOIP)

BTIPBTIC=count({<IBTICBTIP={1}>} distinct PHT_IDTTIC)

TickInternational=($(scope0) + $(scope1) + $(Scope2))

scope0=count({<SCOPE0={s0}>} distinct PHT_IDTTIC)

scope1=count({<SCOPE1={s1}>} distinct PHT_IDTTIC)

scope2=count({<ISCOPE2={1}>} distinct PHT_IDTTIC)

So i did that :

if(SCOPE0='s0' or SCOPE1='s1' or ISCOPE2='1' ,'140%','other') it's working well

if i'm trying that

if(IXOIPIS='1' or ISTOIP='1' or IBTICBTIP='1' ,'130%','other') it's working also

but when i'm doing this it's doesn't works anymore

if(SCOPE0='s0' or SCOPE1='s1' or ISCOPE2='1' ,'140%',
if(IXOIPIS='1' or ISTOIP='1' or IBTICBTIP='1' ,'130%','other'))

any idea ?

Thank to all of you for your answers.

Anthony

Re: Error in expression : ')' expected

Digvijay_Singh — Fri, 17 Jun 2016 14:20:47 GMT

Can you share what output you get for the expression you said not workin, as we don't know what do you mean by it doesn't work any more.

Also can you put these condition separately in separate text box -

if(SCOPE0='s0' or SCOPE1='s1' or ISCOPE2='1' ,'140%') in one text box and

if(IXOIPIS='1' or ISTOIP='1' or IBTICBTIP='1' ,'130%','other') in other text box

and share the results.

Re: Error in expression : ')' expected

Anonymous — Wed, 04 Oct 2017 14:05:50 GMT

THANK YOU!! I couldn't figure out why my script was throwing this error. I had comments in a pretty lengthy expression to keep things straight that was causing my error- Not sure if this was the original posters problem, but definitely helped me. Thank you!