topic Re: Set Analysis Restrict in QlikView

Set Analysis Restrict

userid128223 — Tue, 31 Jul 2012 20:32:28 GMT

I have a master calandar that is tied to Straight Table with multiple different dates.

Purchase Date Shipped Date Invoice Date

01/11/2007 01/11/2007 20/01/2008

01/08/2007 01/09/2007 22/09/2007

05/10/2009 05/14/2009 20/02/2010

01/06/2010 01/06/2010 20/12/2010

Requirement:

1) When i select Month and Year on Calander (which is created with all the dates combined from above 3 dates).I want the straight table to only show range of dates within that selected time period.

Re: Set Analysis Restrict

Jason_Michaelides — Tue, 31 Jul 2012 22:32:35 GMT

Can you post an image of your data model?

Re: Set Analysis Restrict

userid128223 — Wed, 01 Aug 2012 04:55:24 GMT

Re: Set Analysis Restrict

Jason_Michaelides — Wed, 01 Aug 2012 06:21:44 GMT

I'm not sure why your solution isn't already working, although I think you'd be better off switching your data model around and creating a single date field on the sales table. Can you post your app?