topic Re: How to create a set analysis for calculating average in QlikView

How to create a set analysis for calculating average

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I need to create a set analysis expression for :

Avg( field_value when max of selected date , field_value when max of selected date) . How is this possible?

Basically I have a table with counts for a yearmonth date. So foa a selection made I need to do an average of the count between the max and min selected date.

Re: How to create a set analysis for calculating average

ychaitanya — Tue, 13 Feb 2018 00:34:29 GMT

Hi Anitha

You could try as follows:

Create two variables for the mindate and maxdate as vmindate and vmaxdate

Avg({<Date={">$(=$(vmindate) )<= $(=$(vmaxdate))"}>}Sales)

Please try and mark the response as per the result.

Thanks

Re: How to create a set analysis for calculating average

Digvijay_Singh — Tue, 13 Feb 2018 00:39:19 GMT

May be something like this -

Avg({<Date={">=$(vminDate)<=$(maxDate)"}>}field_value)