List boxes

[Anonymous]

Hi guys,

Is there a way to combine list boxes to look at two different date selections in tables?  Hopefully the screenshot will help this make sense!

I have got some list boxes which are looking up dates in two different tables.  What would be great is to have a single list box for both date and month which looks at both my tables when selected. 

Could I do this by creating an expression on the list boxes somehow?

[djsampat · Accepted solution]

Hi,

You can make the fields have the same name, so they get linked.

LOAD

day(OrderDate) as Day

month(OrderDate) as Month

from ORDERS;

LOAD

day(TicketDate) as Day,

month(TicketDate) as Month

from TICKETS;

or just make both dates as your DocDate and link it to a Master Calendar

If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer

Regards

Dhruv

[jyothish8807]

Hi Jamel,

I guess both dates are different so making them one will create an issue in this case the best solution i suggest is creating a canonical dates.

refre this:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date

Regards

KC

[ankit777]

hi,

Maybe u can concat both date tables and add a flag like Day order and day tickets.

This gets all your dates in one table and they can be distinguished on the basis of flag.

Thanks.