Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

lilley90
New Contributor III

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

Re: Duplicate date on list box

And format the result as a Date

Date(Floor(Date)) as Date

9 Replies

Re: Duplicate date on list box

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

Floor(Date) as Date

Re: Duplicate date on list box

And format the result as a Date

Date(Floor(Date)) as Date

lilley90
New Contributor III

Re: Duplicate date on list box

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

MVP
MVP

Re: Duplicate date on list box

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.

lilley90
New Contributor III

Re: Duplicate date on list box

Thank you

Re: Duplicate date on list box

Can you share the script you tried?

MVP
MVP

Re: Duplicate date on list box

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/

lilley90
New Contributor III

Re: Duplicate date on list box

Reading about preceding loads cracked it thank you

MVP
MVP

Re: Duplicate date on list box

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

Community Browser