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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Mantix84
Contributor
Contributor

Set analysis using one fixed filter and all the others linked to selection

Good Morning,

I have a Filter Pane related to the year with this expression: 

=[CREATION_DATE.autoCalendar.Year]

Then I have measure in a KPI object with the "1" identifier that currently block all user selection in filter panes, like this:

Count({1<[CREATION_DATE.autoCalendar.Year]={2019}, [TABLE1.STATE]={'TEST,'QUALITY'}, SCHEDULING = {'ACTIVE'} >}[TABLE1.NAME])

I just want to block user selection with filter pane related to the year (so [CREATION_DATE.autoCalendar.Year]={2019} should remain fixed) but leaving selection for any other filter pane. In other words, I don't want to modify the KPI with the selection of the year, but only with others selections)

 

thanks in advance.

 

Labels (1)
3 Replies
miskinmaz
Creator III
Creator III

Just don't use 1 modifier and use $ MODIFIER.

with $ modifier and restricting year to 2019 in set analysis will help to solve ur problem

Mantix84
Contributor
Contributor
Author

Hi, thanks for your response.

With the $ doesn't work as supposed, because the FIlter Pane is continuing to affect the KPI Measure

Mantix84
Contributor
Contributor
Author

Any other solution to solve the problem?