Filter not applied to all columns in table

[a-5]

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!

[Clement15]

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]

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

[Clement15]

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