Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Discussion Board for collaboration related to QlikView App Development.
Do as follows:
TMP:
LOAD min([Week Start Date]) as mini, max([Week Start Date]) as maxi esident [SKU Segmentation];
Let vMin = peek('mini',0,'TMP');
Let vMax = peek('maxi',0,'TMP');
drop table TMP;
now in your query write
....
where [Week Start Date] >= $(vMin ) AND [Week Start Date] <= $(vMax);
let me know