Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
vandith123
New Contributor III

combine 2 or more dates issue

Dear qliks,

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

hicrwunderlichswuehlstevedarkstalwar1filip_duchateausreerangasane

1 Solution

Accepted Solutions

Re: combine 2 or more dates issue

2 Replies

Re: combine 2 or more dates issue

Re: combine 2 or more dates issue

Hi,

You can not use the aggregation function in variable definition.

Add this code.

//Getting error Date Field is not found

MinMax:

LOad Min(Date) as MIN,

  Max(Date) as MAX

Resident Link; 

Let vMinDate = Peek('MIN',0,'MinMax');

Let vMaxDate = Peek('MIN',0,'MinMax');

Regards,

Kaushik Solanki