Using a filter for another column for only one chart

[ZimaBlue]

Hello!

I have a date range filter by one of the columns for all my charts. But for one chart I want to write: ignore the filter on column 1 (the dimension specified in filter), but use this value for the filter on the other column.

So i need something like:

Count({<Col1=>, Col2=filter value} distinct user_id)

How could I do that?

Thank you!

[ZimaBlue]

Maybe I can create another filter that will automatically take the values of the first filter? Is it possible?

[ZimaBlue · Accepted solution]

I do not know if this is the most elegant solution, since I am new to qlik sense. But I managed to set it up like this:

1. Creating two variables with dates

2. Variables are placed in the main dashboard using the variable extension with the input field type

3. Report user can change these dates, so the values of the variable will change. In the formulas for charts, I refer to these variables for the columns I need.

[chris_djih]

You may have a read on alternate states. Since for other similar problems this can fit your requirement as well, i think.

[ZimaBlue]

unfortunately, I don't have alternate states in master elements section, only dimensions, measures and visualizations