topic Re: Duplicate date on list box in Connectivity & Data Prep

Duplicate date on list box

Anonymous — Fri, 02 Apr 2021 07:59:29 GMT

Hi,

I have two tables linked both with [Date] as a field. But on the list box I have duplicate dates. If you click on one date it gives me data from one table and click on the other duplicate date I get data from the opposite table.

How can I combine?

Many thanks

Re: Duplicate date on list box

sunny_talwar — Thu, 03 Aug 2017 16:24:04 GMT

Try to load the date from both tables using Floor() function

Floor(Date) as Date

Re: Duplicate date on list box

rwunderlich — Thu, 03 Aug 2017 18:04:16 GMT

And format the result as a Date

Date(Floor(Date)) as Date

Re: Duplicate date on list box

Anonymous — Fri, 04 Aug 2017 07:41:02 GMT

One table is a ODBC Connect using SQL select and the as function doesn't seem to work?

Re: Duplicate date on list box

stevedark — Fri, 04 Aug 2017 09:16:43 GMT

You will need to do that function in a preceding load. If you Google this

function you will find plenty of explanations.

Hope that helps.

Re: Duplicate date on list box

Anonymous — Fri, 04 Aug 2017 09:35:50 GMT

Thank you

Re: Duplicate date on list box

sunny_talwar — Fri, 04 Aug 2017 11:09:15 GMT

Can you share the script you tried?

Re: Duplicate date on list box

stevedark — Fri, 04 Aug 2017 16:00:39 GMT

Is that now working for you? This post has lots about preceding loads, if you are requiring it:

https://www.quickintelligence.co.uk/preceding-load-qlikview/

Re: Duplicate date on list box

Anonymous — Mon, 07 Aug 2017 09:42:42 GMT

Reading about preceding loads cracked it thank you

Re: Duplicate date on list box

stevedark — Mon, 07 Aug 2017 10:37:23 GMT

Thanks Jessica, but to be fair Sunny or Rob's answers were correct - my contribution was just a slight tweak on top.