topic Re: Date Combo in QlikView

Date Combo

akpofureenughwu — Fri, 24 Jun 2016 16:29:29 GMT

Good day everyone, I have three csv docs with dates, and I need all these documents to synchronise in terms of dates (same page with dates).

Re: Date Combo

sunny_talwar — Fri, 24 Jun 2016 16:34:33 GMT

Two of the files have start and end date and orders just have a single date. How do you want to link all the stuff?

Re: Date Combo

akpofureenughwu — Fri, 24 Jun 2016 16:44:21 GMT

Sunny.. Thanks for that observation, Can u link just the request and booking start and end date? Or do u have a better suggestions?

Re: Date Combo

sunny_talwar — Fri, 24 Jun 2016 18:41:56 GMT

The script can be improved, but see if this looks like it is going in the right direction

Re: Date Combo

akpofureenughwu — Mon, 27 Jun 2016 12:21:59 GMT

Thanks Sunny but is it possible to remove out every year except 2016?

I usually use the Where statement

where year(date(date#) .............................. <>'1916' and so on...

What line of code will you use?

Re: Date Combo

sunny_talwar — Mon, 27 Jun 2016 13:45:17 GMT

I modified the script to remove all years 2016. Again there are a lot of synthetic keys which doesn't make this a good model to proceed with, but you can start to make improvements by removing synthetic keys here.

Re: Date Combo

akpofureenughwu — Mon, 27 Jun 2016 14:09:33 GMT

Hey bro.. Thanks for the effort. I tried locate the qvw you attached but it didn't respond.

I only need year 2016 in the year list. Thanks Sunny

Re: Date Combo

sunny_talwar — Mon, 27 Jun 2016 14:14:49 GMT

It didn't respond??? Not sure I understand what is wrong