topic Re: Adding Text before Expression not working in QlikView

Adding Text before Expression not working

rustyfishbones — Mon, 26 Aug 2013 09:50:46 GMT

Hi All,

I have the following Expression which works fine

I get the correct answer of 28, however when I had text before it I get -

See below image, it says the expression is ok, it should give me a result of L3 28

Can you help

abeyphilip — Mon, 26 Aug 2013 10:00:09 GMT

Hi Alan,

I think you will have to add one more bracket for the two sum expressions like the one below:

='L3 '&' '&(sum(expr1) - sum(expr2))

rgds,

Abey

rustyfishbones — Mon, 26 Aug 2013 10:03:15 GMT

Excellent, that's it thanks