topic Re: Date between 2 data sources in QlikView

Date between 2 data sources

Wed, 02 Apr 2014 14:08:21 GMT

Hi,

I'm working on a dashboard with 2 data set and both containing multiple months of data. I want to create a slider that allows user to select up to six months data.

Data 1: contains the most recent six months data (Field Name: LONG_DATE)

Data 2: contains 24 months data. (Field Name: End_Date)

How to map them two together so when I select the date on the slider and both data will be apply?

Thank you!

Jasmine

Re: Date between 2 data sources

alexandros17 — Wed, 02 Apr 2014 14:13:21 GMT

You must call with the same name both fields data:

Load

...

LONG_DATE as mydate

...

load

...

End_Date as mydate

...

Use mydate as field in the slider

Re: Date between 2 data sources

its_anandrjs — Wed, 02 Apr 2014 14:15:56 GMT

If there is common field between two tables or if this dates in the same table then use variables like

Let vMin1 = Peek('Date',0,'Temp');

Let vMax1 = Peek('Date',-1,'Temp');

Let vMin2 = Peek('Date2',0,'Temp');

Let vMax2 = Peek('Date2',-1,'Temp');

and use this variables in the slider objects.

Let me know

Hope this helps