topic Re: Using different Start dates in QlikView

Using different Start dates

Tue, 28 Oct 2014 04:48:04 GMT

Hi,

I have a requirement wherein two dashboards are to be developed

one of which must have its date starting with 1-Jan-2010 and the last date as today's date

other dashboard must have the start date as start date of the current week and the end date as last date of the current week.

Note: Both the dashboards will be referring two different date fields

Please let me know how this could be achieved in the same applications.

jagan — Tue, 28 Oct 2014 05:10:38 GMT

Hi,

Filter the records in Dashboard like below

Dashboard1:

Data:

LOAD

FROM DataSource

WHERE DateDimension1 < Today();

Dashboard2:

Data:

LOAD

FROM DataSource

WHERE DateDimension2 >= WeekStart(Today()) AND DateDimension2 >= WeekEnd(Today()) ;

Note: Replace DateDimension1 and DateDimension2 with your actual date fields .

Regards,

Jagan.

Tue, 28 Oct 2014 06:15:31 GMT

You can try creating Sheet trigger to limit the data set.

For the Main Dashboard, OnActivate, you can set the DateField to be from 01-Jan-2014 to Today()

And for next tab say Weekly Data, you can set DateField from current week to last date of the current week.

Hope this was helpful

Thanks,

Singh