interaction of multiple filter panes with each other

[denispillay]

i have 6 filter pane 

(1) Normal week

(2) Special week

(3) Section 

(4) year

(5) month

(6) Day

when user will select 1st filter pane then (3,4,5,6) should show all possible value related to filter pane 1st,

when user will select 2nd filter pane then  (3,4,5,6) should show all possible value related to filter pane 2ND,

kindly guide me for solution 

[cristianj23a]

Hello, let's see if I understand, do you want all the filters to be related?
For example we have filter 1 and filter 2, if I filter any data from FILTER1, in FILTER2 it must also be filtered and show the data related to FILTER1.

If so, then it depends on your data model.

Something like that?

Products:
LOAD * INLINE [
ProductID, ProductName, ProductCategory
1, "Producto 1", "Categoria 1"
2, "Producto 2", "Categoria 2"
3, "Producto 3", "Categoria 3"
4, "Producto 4", "Categoria 4"
5, "Producto 5", "Categoria 5"
];

Sales:
LOAD * INLINE [
SaleID, ProductID, SaleDate, SaleAmount
101, 1, "2023-01-01", 500
102, 2, "2023-02-01", 600
103, 3, "2023-03-01", 700
104, 4, "2023-04-01", 800
105, 5, "2023-05-01", 900
];

Regarts.

[denispillay]

thanks for reply,

this is not  exactly i  want 

i want when i use filter 1st (normalweeK) then in filter 3,4,5,6 should show all possible result related to filter 1st (normalweek) 

but when i use filter 2Nd  (specialweeK) then in filter 3,4,5,6 should show all possible result related to filter 2nd (special week) 

[marcus_sommer]

If the data-model is properly build all data have an association to each other and then the selection of any values in the filter-pane will force all other objects to the left possible values. It's the default behaviour of Qlik and nothing else needs to be done - unless of having a valide data-model.

[cristianj23a]

Hi dennis.
What you ask me is a data model, to do it you must relate the tables in a script or automatic model that qlik offers.
One of the conditions it asks for is that both tables have a relationship key field.

Here I send you a document.

https://help.qlik.com/es-ES/sense/May2023/Subsystems/Hub/Content/Sense_Hub/DataModeling/view-data-mo...

Regarts.

[denispillay]

im not able to find out perfect solution for that 

[marcus_sommer]

Just start at the beginning and check if your data-model is suitable for all wanted view because it will define the possibilities within the UI.

[cristianj23a · Accepted solution]

Hi Dennis, I recommend you do some research on data models.
Especially star type model, that will help you a lot.