This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I think I missed out something here. The variable I created is not showing at all in my variables tab.
Here is my code.
LOAD Date as Dyn_Date,
Week as Dyn_Week,
Year as Dyn_Year
(ooxml, embedded labels, table is Raw);
Let vmaxDate = max(Dyn_Date);
You can't do it like that.
You need to do a resident load on the table Dynamic:
Dynamic_MaxDate:LOAD max(Dyn_Date) as MaxDateResident Dynamic;
max(Dyn_Date) as MaxDate
then you can peek at the maxdate value.
LET vmaxDate = peek('MaxDate');
And now that we don't need dynamic_MaxDate we drop it:
drop table Dynamic_MaxDate;
Hope it helps.
View solution in original post
Let vmaxDate = '=max(Dyn_Date)';
mwoolf wrote: Try:Let vmaxDate = '=max(Dyn_Date)';
mwoolf, this displays the vmaxDate in the Variables tab but not properly evaluating it.
Carlos, i will definitely try it now.
But the thing is, just yesterday, i think i was able to make it work by ticking on some options in Document Properties.