topic Re: Expression wise Average in QlikView

Expression wise Average

nuwanhwb87 — Mon, 26 Jan 2026 21:26:37 GMT

Hi All,

Need a Help.

My above table is a pivot Table.

Dimension in Month. Expressions are Efficiency, Running Machine, Quality Rate.

Unable to get the last column in the above attached image (Avg/Total ) by Expression wise

Please help...

MayilVahanan — Tue, 16 Feb 2021 02:53:27 GMT

Try like below

Dim:
load * inline [
Dim
1
2
];

Dim:

=If(Dim=1, Month, 'Avg/Total')

Expression:

If(Dim=1, urexp, avg/total expression)

nuwanhwb87 — Thu, 25 Feb 2021 12:31:39 GMT

Sorry . Didn't get this.

In the chart

Dimension is month - (But it has change in the Display as a Field/ But originally it is dimension )

Expression - Efficiency

Running Machine

Quality Rate