topic Re: One Date Selection Source, for multiple data sets in QlikView

One Date Selection Source, for multiple data sets

Tue, 21 May 2013 11:38:31 GMT

Hi,

How do i create one set of dates for filtering purposes that will filter both data sources.

I have one set of records that are hourly records of money made. (Datetime)

The second are automated messages that get sent out, also time stamped.

How do I get both sets of data to filter when I select dates in a List box?

Re: One Date Selection Source, for multiple data sets

Gysbert_Wassenaar — Tue, 21 May 2013 12:00:21 GMT

See this tutorial. The tutorial selects in only one date field, but you can simply add the same kind of Select in Field actions for another field to make the selections in that other field too.

Re: One Date Selection Source, for multiple data sets

Tue, 21 May 2013 14:34:52 GMT

Why not just set them up to be a common key

table1:

qualify *;

unqualify date;

load

date,

sales,

employee

from sql select blah blah blah table1

table2:

qualify *;

unqualify date;

load

date,

sales,

employee

from sql select blah blah blah table2

Re: One Date Selection Source, for multiple data sets

Tue, 21 May 2013 14:41:31 GMT

Gives me errors?

Re: One Date Selection Source, for multiple data sets

Tue, 21 May 2013 15:16:19 GMT

I think that the code before your first line above as not got a terminator ";"

change

Collections:

qualify *;

to be

;

collections:

qualify *;

Also the field you are unqualifying needs to exist as one of your load fields so

unqualify CollectionEndTime; would be fine

but because you have not done a load on CollectionEndDate then

unqualify CollectionEndDate; will fail.