Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
a-5
Contributor III
Contributor III

Filter not applied to all columns in table

Hi,

I have the following table in my Qliksense sheet (targets are defined on annual level & sales can be filtered per monthly if needed): 

Product Sales Target
A 10 15
B 8 20
C 5 25

 

Currently, if the user selects one period (e.g. Jan/2024), the target column is filtered and updated as well (which results as showing incorrect value in the target column). 

How can I define the month filter so that it's not impacting Target values in the table/chart? 

Thank you!

Labels (1)
3 Replies
Clement15
Creator III
Creator III

Hello, if you don't want Target to be influenced by the month filter, you can use this syntax: sum({<Month=>}Target)
In this situation, the Month filter won't impact the column, but the other filters will. Be careful, filtering with the month in this way only works if you have a calendar.

a-5
Contributor III
Contributor III
Author

Unfortunately, this didn't work in my case. Any other ideas how to solve this? Thanks!

Clement15
Creator III
Creator III

You can create a manual sort in this way with a mapping, this should allow you to sort as you want.

 

Clement15_0-1709716656048.png