Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Separating Date Filters

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.

Gauge Issue.png

5 Replies
Not applicable

Re: Separating Date Filters

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.

avastani
Contributor II

Re: Separating Date Filters

Island table is another option as well

shaik_basha
Contributor III

Re: Separating Date Filters

hi,

  can you please forward the test application.

Regards

Not applicable

Re: Separating Date Filters

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.

manojkvrajan
Contributor III

Re: Separating Date Filters

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.

Community Browser