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: 
1adam_haj
Contributor III
Contributor III

Ignore of particular field selection

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)IDValue1Value 2calculated value
1.1.2018 15:0015510
2.1.2018 16:002101020
3.1.2018 17:003202030

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)IDCValue1CValue 2calculated value3
1.1.2018 15:001000
2.1.2018 16:002000
3.1.2018 17:003202030

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

1 Solution

Accepted Solutions
OmarBenSalem

try to alter:

sum(Value)

to

sum({<YourTimeStampField>}Value)

View solution in original post

4 Replies
OmarBenSalem

try to alter:

sum(Value)

to

sum({<YourTimeStampField>}Value)

1adam_haj
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

Ok, thank you very much for your help