topic Re: Variable Date from Calendar in QlikView

Variable Date from Calendar

Anonymous — Wed, 16 Dec 2015 17:43:15 GMT

Hi All,

I have an app that has several calendars, and I am trying to create a variable based on a month date from that calendar date. Everything that I can find so far seems to be a variable based on set dates, or other formulas such as Today().

What I'm looking for is essentially just the current OppMonthYear, less one month.

Can this be done?

Re: Variable Date from Calendar

sunny_talwar — Wed, 16 Dec 2015 17:51:05 GMT

Not entirely sure what you mean. But may be this:

Temp:

LOAD Date(AddMonths(Max(OppMonthYear), -1)) as NeededOppMonthYear

Resident Opp_Calendar;

SET vNeededOppMonthYear = Peek('NeededOppMonthYear');

DROP Table Temp;

Re: Variable Date from Calendar

Anonymous — Wed, 16 Dec 2015 18:11:24 GMT

Sunny,

You're on the right track regarding what I'm looking for. However that script seems to return only a text value of Peek('NeededOppMonthYear');

Re: Variable Date from Calendar

sunny_talwar — Wed, 16 Dec 2015 18:16:23 GMT

What about this:

Temp:

LOAD Num(AddMonths(Max(OppMonthYear), -1)) as NeededOppMonthYear

Resident Opp_Calendar;

SET vNeededOppMonthYear = Peek('NeededOppMonthYear');

DROP Table Temp;

Re: Variable Date from Calendar

Wed, 16 Dec 2015 18:17:59 GMT

Hi Dan, try this:

Temp:

LOAD Num(AddMonths(Max(OppMonthYear), -1)) as NeededOppMonthYear

Resident Opp_Calendar;

SET vNeededOppMonthYear = Peek('NeededOppMonthYear' , 0 , Temp);

DROP Table Temp;

I hope that it help you! ifnot just ask us!

Agustin

Re: Variable Date from Calendar

Anonymous — Wed, 16 Dec 2015 18:24:07 GMT

Same thing. It seems that the Peek is not coming back as a function.

Re: Variable Date from Calendar

Anonymous — Wed, 16 Dec 2015 18:25:05 GMT

Same thing as before. It seems that in both yours and Sunny's scrip it's not picking up the PEEK as a function.

Re: Variable Date from Calendar

sunny_talwar — Wed, 16 Dec 2015 18:28:20 GMT

I think i understand what you are trying to do. But the question is are you going to be using this variable in the script? because if you do, then you cannot use functions in scripts, you would need to change it to a static value. If this is for front end (and will change based on selections) then why don't you create this on the front end itself?