topic Re: Setting a Variable based on another in QlikView

Setting a Variable based on another

shane_spencer — Mon, 05 Sep 2016 14:32:59 GMT

I've got two variables:

LET vDashDate = Date(Today()-1,);

LET vDashMonthYear =Month('$(vDashDate)') & ' ' & Year('$(vDashDate)');

Unfortunately for vDashMonthYear instead of reading to be =Month('$(vDashDate)') & ' ' & Year('$(vDashDate)') my load script replaces the vDashDate with the actual date not the variable. How can I fix this so vDashMonthYear is dynamic?

Re: Setting a Variable based on another

sunny_talwar — Mon, 05 Sep 2016 14:41:06 GMT

May be this:

LET vDashDate = Date(Today()-1);

LET vDashMonthYear = '=Month($' & '(vDashDate)) & ' Chr(39) & ' ' & Chr(39) & Year($' & '(vDashDate))';

Re: Setting a Variable based on another

juleshartley — Mon, 05 Sep 2016 14:42:15 GMT

Why can't you just write this straight into the variable rather than do it in the script?

Otherwise you'll need to add quotes etc. as per Sunny's reply

Re: Setting a Variable based on another

saimahasan — Mon, 05 Sep 2016 15:17:04 GMT

You can write it as

LET vDashDate = Date(Today()-1);

LET vDashMonthYear = Month(Date(Today()-1)) & ' ' & Year(Date(Today()-1));

Re: Setting a Variable based on another

shane_spencer — Tue, 06 Sep 2016 07:43:54 GMT

That's not working.

Re: Setting a Variable based on another

shane_spencer — Tue, 06 Sep 2016 07:44:16 GMT

I have done as a work-around but it's not a good practise.

Re: Setting a Variable based on another

shane_spencer — Tue, 06 Sep 2016 07:44:47 GMT

No the second variable must change is I change the first.

Re: Setting a Variable based on another

Peter_Cammaert — Tue, 06 Sep 2016 07:58:28 GMT

Maybe like this?

LET vDashDate = 'Date(Today()-1,)';

LET vDashMonthYear = '=Month($' & '(vDashDate)) & ' & chr(39) & ' ' & chr(39) & ' & Year($' & '(vDashDate))';

I don't know where you'll be using vDashMonthYear so depending on the context you may have to drop the initial '=' from the right hand part of the second LET statement.

Peter