Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI Team,
Can we restrict filters like below mentioned??
when I select Funnel 1, then set of filters i have, Filter A , Filter B, Filter C should apply only on Funnel 1 view ,
when I select Funnel 2 then, same set of filters should apply only on Funnel 2 View.
This kind restriction is possible in qlik?
Not sure what you mean by "Select funnel 1", but generally speaking it sounds like you're after Alternate States, so have a look at using those.
Hi, you can try "ignore" some filters in Funnel 1 or 2 measure expression using set analysis, f.e:
Funnel-1: sum({<[Filter D dim]=, [Filter E dim]=>} measure1)
Funnel-2: sum({<[Filter A dim]=, [Filter B dim]=, [Filter C dim]=>} measure2)
Hi @Amala,
You can achieve this using Alternate States. Alternate States allow you to assign different states to filters and visualizations, enabling independent selections within the same sheet or app.
This means you can have different sets of filters apply to different visualizations without affecting each other.
Step-by-Step Solution:
Creating Alternate States:
Open your Qlik Sense app.
Navigate to the Master Items panel on the right-hand side.
Under Alternate States, click on Create new state.
For example:
Create a state named Funnel1.
Create another state named Funnel2.
Assigning States to Filters:
Add your filters (Filter A, Filter B, Filter C) to the sheet.
Select each filter one by one.
In the properties panel (Selections), you'll see a drop-down called Alternate State. Assign Funnel1 for Funnel 1 view filters and Funnel2 for Funnel 2 view filters.
Assigning States to Visualizations:
Select the visualizations that correspond to Funnel 1.
In the properties panel, set the Alternate State to Funnel1 to ensure that these visualizations only respond to the Funnel 1 filters.
Similarly, assign the Funnel2 state to visualizations that correspond to Funnel 2.
*****Hope this will help you to resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.******
Hi TauseefKhan thank you for your support.
We should have same set of filters for both funnels. Only thing is that when i select Funnel-1 tab then only selected filters should apply on funnel -1 chart.