topic Re: expression error in QlikView

expression error

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

hi All

i have caluted values in the variable and trying to show this value by dollar symbol but its showing error , can someone please correct me how to write this

please find the screenshot

Re: expression error

kaushiknsolanki — Thu, 06 Jul 2017 11:03:58 GMT

Screenshot missing.

Anyways you can try adding '=' sign at starting of expression, if you have not added.

Regards,

Kaushik Solanki

Re: expression error

tajmohamed30 — Thu, 06 Jul 2017 11:08:18 GMT

have you tried applying the format in the numbers tab and remove here in the expression

Re: expression error

sunny_talwar — Thu, 06 Jul 2017 11:11:16 GMT

How do you define vMet$ here?

Re: expression error

Kushal_Chawda — Thu, 06 Jul 2017 11:12:41 GMT

what is the expression variable?

Re: expression error

smilingjohn — Thu, 06 Jul 2017 11:40:05 GMT

Hi Sunny

vMet has two variable it is sutituing vFcon-vFxe

Re: expression error

sunny_talwar — Thu, 06 Jul 2017 11:43:36 GMT

How are vFcon and vFxe defined?

Re: expression error

marcus_sommer — Thu, 06 Jul 2017 12:14:41 GMT

The syntax is wrong. There is an extra bracket before your second vcurrencysymbol-variable - and they makes no sense because both parts of the formatting are the same - and then there is a missing closing-bracket after the formatting. And of course it will be only work if your first variable contained something like:

num($(vFcon) - $(vFxe)

Another point is the $-sign within the variable-name. I have never tried if it will work but in general the special-chars respectively statements of a program should be avoided in any names - it might cause strange errors which are difficult to find.

Beside the invaluable usefulness of variables the usage could be exaggerated when applied to nearly each (part of an) expression. The use should be simplify things and not add a rather big amount of complexity or administration to handle them - just a suggestion ...

- Marcus