topic Using a filter for another column for only one chart in App Development

Using a filter for another column for only one chart

ZimaBlue — Wed, 02 Feb 2022 14:52:12 GMT

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!

Re: Using a filter for another column for only one chart

ZimaBlue — Sun, 06 Feb 2022 10:58:44 GMT

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

Re: Using a filter for another column for only one chart

ZimaBlue — Wed, 09 Feb 2022 09:54:46 GMT

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.

Re: Using a filter for another column for only one chart

chris_djih — Wed, 09 Feb 2022 12:02:29 GMT

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

Re: Using a filter for another column for only one chart

ZimaBlue — Thu, 10 Feb 2022 09:26:42 GMT

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