Qlik Community

QlikView Expressor

Discussion Board for collaboration related to QlikView Expressor.

nikolis_gr
New Contributor II

Busy hour, pivot table column calculation

Hi community,

I am using Qlik Sense and I would like your help with the following:

I have created a pivot table with 2 dimensions and 1 measure. Dimensions are Sampled( time series) and ResourceName( which is actually network interfaces). The measure is Max Rate.

I am using

Max(TOTAL Aggr(RangeSum(Above([MAX_RATE],0,4)), RESOURCE_NAME, ([SAMPLED], (Ascending))

to calculate the busy hour ( the max of sum of 4 InboundRate in a row)

This works if I put the measure in a separate Text&Image box and filter the resource name.

How can I use it/modify it so as to report the busy hour of each Resource in a column? In other words how can I add the busy hour in a separate column so as to report the busy hour for every resource?

1 Solution

Accepted Solutions

Re: Busy hour, pivot table column calculation

may be like

Max(TOTAL <RESOURCE_NAME> Aggr(RangeSum(Above([MAX_RATE],0,4)), RESOURCE_NAME, ([SAMPLED], (Ascending))

3 Replies
arvind_patil
Valued Contributor II

Re: Busy hour, pivot table column calculation

Hi Nikos,

Please provide the sample data.

Thanks,

Arvind Patil

Re: Busy hour, pivot table column calculation

may be like

Max(TOTAL <RESOURCE_NAME> Aggr(RangeSum(Above([MAX_RATE],0,4)), RESOURCE_NAME, ([SAMPLED], (Ascending))

nikolis_gr
New Contributor II

Re: Busy hour, pivot table column calculation

Thank you for the fast responses.

It works!!!!!

Community Browser