Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
akpofureenughwu
Contributor III

Date Combo

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).

1 Solution

Accepted Solutions

Re: Date Combo

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

View solution in original post

7 Replies

Re: Date Combo

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?

akpofureenughwu
Contributor III

Re: Date Combo

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

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

View solution in original post

akpofureenughwu
Contributor III

Re: Date Combo

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

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.

akpofureenughwu
Contributor III

Re: Date Combo

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

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