Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Amit_B
Creator II
Creator II

Setting a constant filter & Using a variable as a filter

Hi experts,

I have a big mess with the filters and the set analysis, I have several problems.
I am using 4 main variables - 2 are for the KPIs and 2 are for the other objects.

For each KPI I am using Set Analysis and define each variable to the relevant field.
For example: Sum({<Year={'$(vKpiYear)'}, Month={'$(vKpiMonth)'}, Flag1={1}>}Sales)
The KPIs should not be affected by any user selection, not even selections in the fields listed in the Set Analysis.
When I added 1 to the Set Analysis, only the mentioned fields (Year, Month, Flag1) affect the KPIs, but that shouldn't happen either.
Sum({1<Year={'$(vKpiYear)'}, Month={'$(vKpiMonth)'}, Flag1={1}>}Sales)

The rest of the objects should affect by user selection in the filter panes.
I need to use the other 2 variables to set a default filter in a filter pane (a dynamic filter that updated every month) - set the value of vSelYear as default of Year and set the value of vSelMonth as default of Month. The user can change this defauld and filter by additional fields. Every selection will affect all objects except the KPIs.
My problem is associating the variable value to a field in the filter panes.

The client prefers that I not use Alternate State for the first problem and refuses to use extension for the second problem.
How can the problems be solved?

Hope I was clear. Many Thanks!

Labels (5)
1 Reply
md_talib
Contributor III
Contributor III

R you using Linked or Unlinked calendar?? 

If you r using a linked calendar kindly check the variables that you have made from Master Calendar Dates?

May be you are using a different table dates in variable and you have made you master calendar from different table.