Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
fvarlet
Contributor II
Contributor II

Create a filter pane not fully dependant of another filter pane

Hello,

I would like to add a filter pane for the dimension [Category], while I already have another filter pane for the dimension [_MonthYear].

[_MonthYear] is a field of my Master Calendar and represents the last displayed month on my dashboard, which can cover a period of several months.

As there aren't all categories every month, some categories may be greyed out.

I've tried:

 

Aggr(Only({1} Category), Category)

as dimension of my filter pane, but they're still greyed.
I've also tried to include a set analysis like:

=Aggr({<$(vEmptyDate)>} Reporting,Reporting)

where the variable vEmptyDate is defined as:

%DateKey=,
_Date=,
_DayMonth=,
_WeekDay=,
_Week=,
_WeekYear=,
_Month=,
_MonthYear=,
...

But it doesn't work neither.

 

What could be the solution?

Thank you in advance for your help.

Labels (2)
11 Replies
fvarlet
Contributor II
Contributor II
Author

Hello,

Have you found a way to keep all categories selectable with the selection of a specific month?

fvarlet
Contributor II
Contributor II
Author

I have found a temporary solution, with the creation of a second master calendar, but I'm not sure it's the best solution