topic Re: List boxes in QlikView

List boxes

Anonymous — Thu, 06 Nov 2014 13:55:18 GMT

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?

Re: List boxes

djsampat — Fri, 07 Nov 2014 06:53:43 GMT

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

Re: List boxes

jyothish8807 — Fri, 07 Nov 2014 06:58:15 GMT

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

Re: List boxes

ankit777 — Fri, 07 Nov 2014 08:07:51 GMT

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.