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: 
Not applicable

Set Analysis

How can we write set analysis expression for showing Avg(Population) for dates less than X.

For example, if I have population value at 3 different dates (W, X, Z), I would like to show Avg(Population) for all the dates less than X. Average value should not include population value at Z.

1 Reply
Not applicable
Author

Hi,

Let vDate=Max(x);

avg({<Date={'=<($(vDate))'}>} Population)