topic Setting a simple variable in QlikView

Setting a simple variable

samvile18 — Tue, 03 Apr 2012 11:52:30 GMT

Afternoon everyone,

I'd like to set a variable in my script called vMaxExtractDate...I basically need the value to be the maximum date with the field Extract Date, this is what I have so far and the value is always blank:

SET vMaxExtractDate = Max(Date([Extract Date]))

Can anyone help me please?

Setting a simple variable

vijay_iitkgp — Tue, 03 Apr 2012 12:03:17 GMT

Please do like:

Table1:

Load Distinct

Max([Extract Date]) as MaxDate

From/Resident Table;

Let vMaxExtractDate=Date(Peek('MaxDate',0,'Table1'));

Hope this will help

Setting a simple variable

samvile18 — Tue, 03 Apr 2012 12:05:39 GMT

Thanks for the help Vijay, this was my next test and it works brilliantly.