Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Duplicate date on list box

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

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

And format the result as a Date

Date(Floor(Date)) as Date

View solution in original post

9 Replies
sunny_talwar

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

Floor(Date) as Date

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

And format the result as a Date

Date(Floor(Date)) as Date

Anonymous
Not applicable
Author

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

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Not applicable
Author

Thank you

sunny_talwar

Can you share the script you tried?

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Not applicable
Author

Reading about preceding loads cracked it thank you

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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