topic Re: Select in field, date between and null values in QlikView

Select in field, date between and null values

Wed, 01 Jun 2016 11:38:01 GMT

Hi All,

I have problem with Select in field. Now my results shows only values that are between my search.

I have NULL values in 'Enddate' field. They all have 'Startdate'. So what I am missing is to have also those dates that don't have Enddate, but have Startdate. Startdate should be < vDatedEnd.

I have named all NULL values to 'Toistaiseksi'.

vDatedStart vDatedEnd

Now I have two 'Select in Field' Action in search tab.

Is there any solution to do this?

I will be thankful for any help!

-Marko

Re: Select in field, date between and null values

sunny_talwar — Wed, 01 Jun 2016 13:22:50 GMT

Would you be able to share your application where you are testing all this?

Re: Select in field, date between and null values

Wed, 01 Jun 2016 13:32:29 GMT

Hi Sunny,

I'm sorry, that is not possible. There is too much private information.

-Marko

Re: Select in field, date between and null values

sunny_talwar — Wed, 01 Jun 2016 15:19:25 GMT

Have you looked at this thread?

Preparing examples for Upload - Reduction and Data Scrambling

Re: Select in field, date between and null values

Thu, 02 Jun 2016 08:34:34 GMT

Thank you for that link.

I added that application in my earlier post

-Marko

Re: Select in field, date between and null values

Mon, 20 Jun 2016 07:14:38 GMT

Hi,

Is there any solution?

Regards,

Marko

Re: Select in field, date between and null values

Anonymous — Thu, 07 Jul 2016 13:47:28 GMT

Marko,

Just a thought can you input some infinite date in the end date if there is null value. if the start date reaches the infinite date increment the end date year by 10 years. Hopefully that should solve your problem.

Re: Select in field, date between and null values

sunny_talwar — Thu, 07 Jul 2016 14:31:02 GMT

I was unable to get this to work, may be swuehl‌ can offer his expert advice.

Best,

Sunny

Re: Select in field, date between and null values

boorgura — Thu, 07 Jul 2016 14:38:59 GMT

Try using this expression as search string in the EndDate action

='(">=$(-date($(vDatedStart)))"|"Toistaiseksi")'

Re: Select in field, date between and null values

vinieme12 — Thu, 07 Jul 2016 15:11:43 GMT

Hi,

Please find attached qvw for reference, hope it helps

Cheers