topic Select two date fields with one selection? in QlikView

Select two date fields with one selection?

raynac — Mon, 30 Apr 2012 15:10:57 GMT

I am trying to create a system whereby my user chooses a date (or multiple dates) from a single selection box and it chooses two separate (unrelated) dates.

So as an example, we have a service date in tableA and a call date in tableB. My company owner wants to be able to choose dates in one single place/selector box and get all tableA.service_dates AND all tableB.call_dates that match that one date selection.

I am looking at calendar items, but those look like they still connect to a single date field.

I assume this would have to be somethingin the script but does anyone have an ideas as to how this can be accomplished, or even if it can?

Thank you all in advance for any insight you might have!

Select two date fields with one selection?

jagannalla — Mon, 30 Apr 2012 15:16:34 GMT

TableA:

Load

*,service_dates as DateField

From TableA;

TableB:

Load

*,call_dates as DateField

From TableB;

Hope it helps you.

Select two date fields with one selection?

raynac — Mon, 30 Apr 2012 16:15:39 GMT

Thank you! I gave this a try, but I believe I gave the wrong impression when I said "unrelated" - my apologies. Both tables are eventually linked back to a client table, so I think what's happening is this is creating a "circular reasoning" situation and it errors out at the end of the load (Execution of Script Failed).

I also tried concatenating all of the dates into a single field, using a three column "bridge" style table(date/call number/service number)...accumulating all the services and all the calls into one table and then trying to use the service numbers and the call numbers to feed back to the applicable place to get the details of each, but I get the exact same error message.

Select two date fields with one selection?

Tue, 01 May 2012 14:34:15 GMT

I have a document that allows the user to select values from two date fields with one click. In my document, the two date fields are named TDATE and START_DATE. I created a list box but not for a single field, in the Properties of the List Box on the General tab, choose <expression> instead of a field name. Then, in the expression dialog, I typed this: =TDATE & ' and ' & START_DATE Now, the list box displays a list of all of the pairs of dates that occur in the data. When I click on an entry in the list box the corresponding date values from each of the fields is selected.

Select two date fields with one selection?

raynac — Wed, 02 May 2012 14:51:06 GMT

Thank you, Tim!! I was unaware that was even possible in Qlikview so you have taught me something that will be userful in other ways, too!

My company owner is very happy 🙂

Re: Select two date fields with one selection?

userid128223 — Fri, 27 Jul 2012 10:28:09 GMT

I tried and this solution does not work for me. Did it work for you guys.

I am trying to connect 2 dates in straight box via one selector object like year or month.

Re: Select two date fields with one selection?

userid128223 — Fri, 27 Jul 2012 10:28:46 GMT

hi Raynac

Did the solution work for you.

Re: Select two date fields with one selection?

raynac — Fri, 27 Jul 2012 15:21:37 GMT

Hi there,

I know it's no longer in the view I built, but because it was several months ago, I can't recall why the company president had me change/remove it. It seems to me that it did work - but for the functionality he needed, this turned out to not really be the right method. I am sorry I can't be any more specific!

Re: Select two date fields with one selection?

userid128223 — Fri, 27 Jul 2012 16:12:39 GMT

Hi Tim

The solution is not working for me. I am trying to combine 2 dates search via one field selection. I tried your solution and it does not work.