Error in expression : ')' expected

[#1]

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

[oknotsen]

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.

[sunny_talwar]

What is $(xxx) here? Variable>

[sasikanth]

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

[Kushal_Chawda]

try with single quotes

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

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

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

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

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

[#6]

if($(TickXOIP),'130',

if($(TickInternational),'140',

if($(fils),'20',

if($(NBDGPM),'30',

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

Yes they are variable

[Anonymous]

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]

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.

[migueldelval]

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

[#10]

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