Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
andre_bento
Contributor III
Contributor III

Creating KPI that disregards current Date selections

Hello everybody, I am using qlik cloud and I want to achieve an expression that calculates the number of teus per day but disregards any current date selections. I am currently using the following expression that considers the date selections: Avg( Aggr(TEU, TRACER_USER_ID, (DATE)) ). So, if I have for example a period of 2 months selected I want my expression to be able to calculate the average number of TEU's per day but for the complete period and not only for those 2 months.

Labels (2)
1 Reply
BenjaminT
Partner - Creator
Partner - Creator

You can list use set analysis to ignore selection in certain fields like this:

avg({<FieldToIgnore= , AnotherFieldToIgnore= >} FieldName)

Does that help?