topic The date problem! in QlikView

The date problem!

Anonymous — Thu, 16 Mar 2017 23:10:08 GMT

Hi experts!

A small challenge regarding dates. I have a table with two dates in it.

Date B will always be greater than Date A. I also have a another date column(calendar) with a list of continuous date values from 1st Jan 2016 to 31/12/2017. I want to any date from from the calendar column, and then check if the selected date is 10 days ahead of the maximum date in Date A column. If yes then show the ID in the straight table in one column, Date A in next and show the maximum date in Date B in the 3rd column.

For example

if I select 01/09/2016 from the calendar date column, my straight table below should show me this

A 15/08/2016 15/09/2016

This is the only line i should get as ID B has a maximum date in Date A 30/12/2016 is not 10 days ahead of the selected calendar date which is 01/09/2016.

I've attached the data if anyone is willing to have a look.

I believe it should be done using first sorted value, aggr and calculated dimension.

Thanks

Re: The date problem!

Anil_Babu_Samineni — Fri, 17 Mar 2017 03:14:30 GMT

Interesting, And we can do the same if you provide QVW

Re: The date problem!

Anonymous — Fri, 17 Mar 2017 08:00:00 GMT

‌will upload in a bit. thanks

Re: The date problem!

Anonymous — Fri, 17 Mar 2017 09:23:57 GMT

I've now attached the qvw file with data loaded.

Re: The date problem!

sunny_talwar — Fri, 17 Mar 2017 11:40:34 GMT

In your example, how are you picking 15/08/2016 for the date? It is neither the min, nor the max date A for ID A? I used Max([Date A]) to get 30/08/2016, but you can change that to whatever you want.....

Also, the solution will only work on a single selection of Calendar.

Knowing you, I am sure this is just the beginning with more to come

Re: The date problem!

Anonymous — Tue, 21 Mar 2017 17:11:45 GMT

Hi Sunny. Thanks for your help.

I'm working on another issue related to average. Would you be able to have a look at it for me?

link: Simple Average Problem