topic Re: Separating Date Filters in QlikView

Separating Date Filters

Fri, 08 Feb 2013 20:55:24 GMT

I have two charts and the data backing the two are the same but need separate date filters. I have attached an image of the sheet. Please help me determine the best method for completing this task.

Re: Separating Date Filters

Fri, 08 Feb 2013 21:33:49 GMT

Are you going to be hard-coding the date range or will it need to be two seperate list boxes to make the date range dynamic? If you want to go "hard-coded" then you can use set analysis; otherwise you could use Alternate States.

Re: Separating Date Filters

avastani — Sat, 09 Feb 2013 17:09:19 GMT

Island table is another option as well

Re: Separating Date Filters

Anonymous — Sat, 09 Feb 2013 17:31:46 GMT

hi,

can you please forward the test application.

Regards

Re: Separating Date Filters

Sat, 09 Feb 2013 17:46:40 GMT

Your sample picture looks like two different metrics for a single date range. But if you want two distinct date (or other dimensions) for two charts that you want to compare, and you are using QV 11, you can use the Alternate States feature to do this easily.

Or depending on the specific requirements, you could just opt to apply Set Analysis that refines the user's existing selections.

Re: Separating Date Filters

manojkvrajan — Sun, 10 Feb 2013 01:08:40 GMT

It is good to create an Island table with the same date and use set analysis to pass the user selection values (to connect with the data model).

Please share the sample application to provide you the solution.