Ignore of particular field selection

[1adam_haj]

Hello, I have a question about ignoring a particular filter selection,
Lets say that i have a simple calculated table like this:

TimeStamp (Atucalendar driven)	ID	Value1	Value 2	calculated value
1.1.2018 15:00	1	5	5	10
2.1.2018 16:00	2	10	10	20
3.1.2018 17:00	3	20	20	30

but when I will apply some timestamp autocalendar filter like Time = 3.1.2018 with multiple ID filters like ID =1,2,3; the table goes like this :

TimeStamp (Atucalendar driven)	ID	CValue1	CValue 2	calculated value3
1.1.2018 15:00	1	0	0	0
2.1.2018 16:00	2	0	0	0
3.1.2018 17:00	3	20	20	30

The qlik did it probably right according to filters, because the data in 1.1. and 2.1 Rows were not included in filter value Time = 3.1.2018, But i need that all of the rows selected by ID filter values will remain calculated no matter of timestamp filter value...

Is that possible to do that and any ideas how ?
Thanks in advance

[OmarBenSalem · Accepted solution]

try to alter:

sum(Value)

to

sum({<YourTimeStampField>}Value)

[1adam_haj]

Great thanks, and how to add this rule in to already existing set analysis in calculated field

sum({<something=1>}Kc) -- how to add {<YourTimeStampField=>} for exclude filter to that existing set analysis ?

[OmarBenSalem]

just seperate with a comma

sum({<something=1 ,YourTimeStampField=>}Kc)

[1adam_haj]

Ok, thank you very much for your help