Duplicate date on list box

[Anonymous]

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

[sunny_talwar]

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

Floor(Date) as Date

[rwunderlich · Accepted solution]

And format the result as a Date

Date(Floor(Date)) as Date

[Anonymous]

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

[stevedark]

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.

[Anonymous]

Thank you

[sunny_talwar]

Can you share the script you tried?

[stevedark]

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/

[Anonymous]

Reading about preceding loads cracked it thank you

[stevedark]

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