topic Re: Expression Error with addition $ in QlikView

Expression Error with addition $

NavinReddy — Mon, 15 Aug 2016 20:46:01 GMT

Dear Experts,

There is syntax issue with my code with '$$' symbols its working as expected.

I don't want to use every where '$$' symbols, Can you please help me to replace $$ symbols with $ with same result.

I have used trim function as well to avoid blanks,any other missing syntax errors. please help me

please find the sample app for reference

Many Thanks,

Niranjan

Re: Expression Error with addition $

vishsaggi — Mon, 15 Aug 2016 20:56:14 GMT

Is this what you are looking for ?

Re: Expression Error with addition $

NavinReddy — Mon, 15 Aug 2016 21:04:42 GMT

yes exactly

Re: Expression Error with addition $

vishsaggi — Mon, 15 Aug 2016 21:10:17 GMT

I just removed the additional $ from your script.

See attached.

Re: Expression Error with addition $

NavinReddy — Mon, 15 Aug 2016 21:24:22 GMT

Hi Nagaraju,

Many Thanks for your reply

still i have a issue i added the few dimensions to that same chart now its not working again.

please find the sample app

Many thanks

Niranjan

Re: Expression Error with addition $

vishsaggi — Mon, 15 Aug 2016 21:33:10 GMT

Is that the same app or you have an updated app? Please attach the sample and expected output? In the above image you have sent you need $ symbol for those two field values ?

Re: Expression Error with addition $

NavinReddy — Mon, 15 Aug 2016 21:40:11 GMT

Hi Nagaraju,

its updated sample app, i followed the same steps you did,now im not able see $ symbol for some of metrics.

this is the issue if can i use $$ symbol it will work as expected. with $ its not working as expected.

Best Regards,
Niru

Re: Expression Error with addition $

vishsaggi — Tue, 16 Aug 2016 00:34:55 GMT

Can i know what selection you made to view those two rows you have sent in your screenshot? Did you select $ from EELE_TYPE_MM_SIGN field? You have written a logic saying if you select $ then your condition else what should it take, If you clear selections what it needs to be displayed ?

Re: Expression Error with addition $

NavinReddy — Tue, 16 Aug 2016 05:58:55 GMT

Hi Nagaraju,

Good Morning, EELE_TYPE_MM_SIGN field with out selections if its EELE_TYPE_MM_SIGN='$' field i want to display '$' before Tier1&Tier3 fields. there are 2 conditions with $, with out sign.

if can i clear the selections EELE_TYPE_MM_SIGN='$' fields need to dispaly $ symbols for some of facts.

Best Regards,

Niranjan

Re: Expression Error with addition $

NavinReddy — Tue, 16 Aug 2016 09:57:32 GMT

Good Afternoon, any suggessions