topic Re: Average in Line Graph in QlikView

Average in Line Graph

Thu, 24 Sep 2015 15:49:41 GMT

Hello. I'm trying to add a line to my combo chart which represents an average by period. Very simple data model. The bars represent total value for the period. The line should represent days_avail (a weighted average). The line only appears as a dot. Can someone take a look? I tried adding the set expression from the value expression to the days_avail expression, but that doesn't seem to work.

Period is single select. If I change it to multi select and select all the periods, the days_avail line appears fine.

Re: Average in Line Graph

Anonymous — Thu, 24 Sep 2015 16:00:42 GMT

Removing the aggr and adding set analysis like this :

=sum({<period={">=$(=Max(period)-1)<=$(=Max(period))"}>} value)

/ sum({<period={">=$(=Max(period)-1)<=$(=Max(period))"}>} total value)

* sum({<period={">=$(=Max(period)-1)<=$(=Max(period))"}>} days_avail)

Give you a line, but I not sure if it is what you actually are after.

Re: Average in Line Graph

Thu, 24 Sep 2015 18:02:31 GMT

Thanks, but that doesn't work. The days_avail changes for a given period as different periods are selected...