Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
1adam_haj
New 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
Partner
Partner

Re: Ignore of particular field selection

try to alter:

sum(Value)

to

sum({<YourTimeStampField>}Value)

View solution in original post

4 Replies
Partner
Partner

Re: Ignore of particular field selection

try to alter:

sum(Value)

to

sum({<YourTimeStampField>}Value)

View solution in original post

1adam_haj
New Contributor III

Re: Ignore of particular field selection

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 ?

Partner
Partner

Re: Ignore of particular field selection

just seperate with a comma

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

1adam_haj
New Contributor III

Re: Ignore of particular field selection

Ok, thank you very much for your help