Discussion board where members can get started with QlikView.
I am attaching an qv app . I want to consider min date and max date dynamically and should given to Auto Generate function for master calendar. Can any one help regarding that.
I have clearly mentioned the problem in qv file with commented lines please take a look through the attached document
Go to Solution.
Try the attached
View solution in original post
You can not use the aggregation function in variable definition.
Add this code.
//Getting error Date Field is not found
LOad Min(Date) as MIN,
Max(Date) as MAX
Let vMinDate = Peek('MIN',0,'MinMax');
Let vMaxDate = Peek('MIN',0,'MinMax');