topic Re: Getting error "Error:Garbage after expression" in Label field in QlikView

Getting error "Error:Garbage after expression" in Label field

Qlikandlearn — Sat, 16 Nov 2024 18:18:23 GMT

Hi,

In Chart object properties, using the variable in label in expression tab, when I click apply, showing this error as "Error: Garbage after expression",

Used variable in Label field : =$(vPrevYear) & 'Total'
VPrevYear : year-1

Can any one help here with the right syntax?

Thanks.

Re: Getting error "Error:Garbage after expression" in Label field

Brett_Bleess — Tue, 11 Aug 2020 18:37:36 GMT

In this case going to be most helpful if you can attach the QVW file, or a sample one that has the issue, so folks can look into the data model and full properties of things, too many things in play without that to really say for sure. If you have any sensitive fields, you can scramble those via the Settings\Document Properties\Scrambling tab prior to attaching.

Regards,
Brett

Re: Getting error "Error:Garbage after expression" in Label field

Saravanan_Desingh — Tue, 11 Aug 2020 19:00:17 GMT

Try to use with out $-expansion.

=vPrevYear & ' Total'