topic Expression problem in QlikView

Expression problem

Fri, 15 Jun 2012 23:17:08 GMT

I'm new to Qlikview and I'm having trouble with an expression.

I don't have access to change script, but create charts and tables from data generated by a SAP system to show on a webview.
My problem is I'm trying to add to an existing expression with no luck.

These two expressions show icons in my tables, but I've created a date input box with a variable (ZSD_PIPELINE.ZZRQDT = vCustRQdate)
and have to add it to all expressions in the table to make it work properly.

IF(ZSD_PIPELINE.cdate_ico = 1,'qmem://<bundled>/BuiltIn/smiley1_g.png','qmem://<bundled>/BuiltIn/smiley1_y.png')

IF(ZSD_PIPELINE.stock_ico = 1,'qmem://<bundled>/BuiltIn/check_g.png','qmem://<bundled>/BuiltIn/cross_r.png')

Any help in accomplishing this would be very welcome.

Thanks Sean

Re: Expression problem

Mon, 18 Jun 2012 05:37:09 GMT

Hi Sean,

What error are you getting? Please elaborate

Thanks

Supriya

Re: Expression problem

Fri, 22 Jun 2012 11:54:53 GMT

Hi Supriya

Thanks for replying and sorry its taken so long for me to answer.

When I try and add the date variable to the existing expression the existing expression doesn't work, but the date variable does.

(ZSD_PIPELINE.ZZRQDT = vCustRQdate)

Existing expression

IF(ZSD_PIPELINE.cdate_ico = 1,'qmem://<bundled>/BuiltIn/smiley1_g.png','qmem://<bundled>/BuiltIn/smiley1_y.png')

Combined

IF((ZSD_PIPELINE.cdate_ico = 1,'qmem://<bundled>/BuiltIn/smiley1_g.png','qmem://<bundled>/BuiltIn/smiley1_y.png'),(ZSD_PIPELINE.ZZRQDT = vCustRQdate))

Thanks in advance for your help

Sean