topic Can't get average function to run in QlikView

Can't get average function to run

Nina — Wed, 21 Jul 2021 13:58:23 GMT

Hello,

I try to set up an expression in a text field. It is not working. I always get "Error: Error in set modifier expression" and the expression is underlined from the closing curly bracket on.

The expression:

=Avg({1<location={London}, Month(target_production_day)=Month(Now()-1)>} production_time)

So, I want to calculate and show the average production time of all entries, which are referring to London in the last month.

Does someone has an idea, what the mistake is here?

Thanks

Nina

Re: Can't get average function to run

rwunderlich — Wed, 21 Jul 2021 17:00:35 GMT

You can't use a function on the left side of = in the set modifier. Instead try this:

=Avg({1<location={London}, target_production_day={"=InMonth(target_production_day, today(2), -1)"}>} production_time)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Can't get average function to run

Harrism05 — Sat, 24 Jul 2021 03:49:13 GMT

Cause: The cell is formatted as Text, which causes Excel to ignore any formulas. This could be directly due to the Text format, or is particularly common when importing data from a CSV or Notepad file. Fix: Change the format of the cell(s) to General or some other format.

Dunkinrunsonyou