topic Re: Garbage after expression : "url" in QlikView

Garbage after expression : "url"

sspawar88 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I have straight table in which written expression is like:

=[ID]& if('$(IsUat)'>0,'$(vULINK)', '$(vPLINK)')

Varibale-->

IsUat -->to pick up the environment like UAT or PROD

vULINK-->if (schema='A', '<url>link1,if (schema='B','<url>link2'));

vPLINK--> if (schema='A', '<url>link1,if (schema='B','<url>link2'));

It gives Garbage after expression : "url" error on straight table.

olivierrobin — Fri, 27 Jul 2018 12:40:53 GMT

i think the ending quotes are missing

if (schema='A', '<url>link1',if (schema='B','<url>link2'))

same for plink

BalaBhaskar_Qlik — Fri, 27 Jul 2018 16:31:59 GMT

You missed the ending Quotes in both variable declarations.

Those variables, should be like:

vULINK-->if (schema='A', '<url>link1',if (schema='B','<url>link2'));

vPLINK--> if (schema='A', '<url>link1',if (schema='B','<url>link2'));

sspawar88 — Tue, 31 Jul 2018 06:58:11 GMT

No that mistake I made while writing the query. plz have a look again

sspawar88 — Tue, 31 Jul 2018 06:58:23 GMT

No that mistake I made while writing the query. plz have a look again