Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Error in expression : ')' expected

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

17 Replies
oknotsen
Honored Contributor III

Re: Error in expression : ')' expected

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.

May you live in interesting times!

Re: Error in expression : ')' expected

What is $(xxx) here? Variable>

sasikanth
Valued Contributor III

Re: Error in expression : ')' expected

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

Re: Error in expression : ')' expected

try with single quotes

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

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

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

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

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

Not applicable

Re: Error in expression : ')' expected

if($(TickXOIP),'130',

if($(TickInternational),'140',

if($(fils),'20',

if($(NBDGPM),'30',

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

Yes they are variable

manucamon
Valued Contributor III

Re: Error in expression : ')' expected

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!

oknotsen
Honored Contributor III

Re: Error in expression : ')' expected

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.

May you live in interesting times!
migueldelval
Valued Contributor

Re: Error in expression : ')' expected

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

Not applicable

Re: Error in expression : ')' expected

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')))))

Community Browser