topic Re: Evaluating Variable in QlikView

Evaluating Variable

janvandernagel — Mon, 02 Jul 2018 15:21:10 GMT

Hello,

I'm trying to use 2 variables:

let vPriorMonth = '=month(addmonths(max(Date),-1))';

let vPriorMonthYear = '=Year(addmonths(max(Date),-1))';

I can call vPriorMonthYear with: ' = $(vPriorMonthYear)'

But when I try the same wiht vPriorMonth (' = $(vPriorMonthYear)') I get no result.

But when I use '=(vPriorMonth)' is it working fine. Why isn't it working when using the$?

Can anyone help me?

Thanks

Jan

Re: Evaluating Variable

Chanty4u — Mon, 02 Jul 2018 15:32:24 GMT

you can check here

The Magic of Variables

Re: Evaluating Variable

Anil_Babu_Samineni — Mon, 02 Jul 2018 15:43:21 GMT

Can you share full variable using SET and LET.. Perhaps this?

=$(=vPriorMonthYear)

Re: Evaluating Variable

janvandernagel — Tue, 03 Jul 2018 06:28:49 GMT

Thanks for your reply.

I've read the article but still do not understand why the 2 variables I use, wich are almost the same, do not behave the same. vPriorMonthYear is working in both ways and vPriorMonth only without the $ sign? I.e.:

= $(vPriorMonthYear) =>2018

= $(vPriorMonth) => -

= (vPriorMonthYear) => 2018

=( vPriorMonth) => apr

Thanks in advance for trying to explane.