topic Re: variables in QlikView

variables

Jamal — Mon, 28 Jan 2019 08:04:01 GMT

Hi friends,

I have this variable in the script : LET vCurrentYear = num(year(today()));

and this variable in variable overview : =If(getpossiblecount ([year])=1, [year], max([year])).

when i reload the document, this function [If(getpossiblecount ([year])=1, [year], max([year]))] is gone .

Could you please help me.

Re: variables

Somasundaram — Mon, 28 Jan 2019 08:10:30 GMT

Hi,

Hope you don;t have separate column name as 'Year'.

you are calculating year from today(). Use as a separate column for getpossiblecount() function.

Re: variables

anushree1 — Mon, 28 Jan 2019 09:50:03 GMT

Thats because Script Variable definition is overwriting the Variable definition in the Variable Overview section,please rename the variable in one of the sections and check

Re: variables

Jamal — Tue, 29 Jan 2019 08:03:23 GMT

Thank you very much