Ignore dimension in pivot table expression

Thu, 23 May 2013 11:07:54 GMT

Hi,

I have a pivot table based on weekday and description that returns an average time. For instance process A runs an average of 12:00 hours at day 1 (as it may run n number oftimes). The total column in Qlikview returns the average time for each description but ignoring the weekday.

My problem is that I want to color cells that are below the weekly average. So I need an expression that computes the average runtime for each process but ignoring the week dimension.

avg(total Processtime) will return the average over the whole set. avg({<weekday=,>} total Processtime) will only ignore the weekday SELECTION but I need to ignore the weekday dimension altogether.

Please help, this seems relatively straightforward but I can't solve it. I've added a screenshot as, unfortunately, I can't share the QV app.

All I need is an avg(processtime) but over dimension 'description'. How to do this?

Re: Ignore dimension in pivot table expression

Gysbert_Wassenaar — Thu, 23 May 2013 11:15:05 GMT

Try avg(total <description> Processtime).

Re: Ignore dimension in pivot table expression

Thu, 23 May 2013 11:26:43 GMT

Thanks Gysbert,

you're a total lifesaver! It was that simple!

topic Ignore dimension in pivot table expression in QlikView

Ignore dimension in pivot table expression

Re: Ignore dimension in pivot table expression

Re: Ignore dimension in pivot table expression