topic combine 2 or more dates issue in QlikView

combine 2 or more dates issue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

hic‌rwunderlich‌swuehl‌stevedark‌stalwar1‌filip_duchateau‌sreerangasane‌

Re: combine 2 or more dates issue

sunny_talwar — Thu, 20 Apr 2017 12:46:50 GMT

Try the attached

Re: combine 2 or more dates issue

kaushiknsolanki — Thu, 20 Apr 2017 12:49:10 GMT

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