topic Re: Sum( aggr(max())) Expression in Combo chart in QlikView

Sum( aggr(max())) Expression in Combo chart

cbaqir — Thu, 23 Jul 2015 21:51:09 GMT

I have exhausted every possibility I can think of with this and hope it's obvious to someone else...

In my attachment, I have two graphs. The first graph shows Allocated vs Actual Non-PTO vs Actual PTO hours.

The second graph shows the Allocated vs Actual Non-PTO vs Actual PTO FULL TIME EQUIVALENT (FTE) resources.

I have no issues with either of the Actual expressions but the FTE expression produces a null resort for Allocated hours.

The only difference is the denominator.

Hours chat: sum(ALLOC_HRS)

FTE chart: sum(ALLOC_HRS)/sum( aggr(max(MONTH_CAP),FISCAL_MONTH_YEAR,FLAG))

Someone please help me correct the err of my ways!

TIA

Cassandra

Re: Sum( aggr(max())) Expression in Combo chart

cbaqir — Tue, 28 Jul 2015 20:25:43 GMT

No one?

Re: Sum( aggr(max())) Expression in Combo chart

settu_periasamy — Wed, 29 Jul 2015 03:33:44 GMT

Hi,

I think, you just missed to look into the Field Name. (it is case sensitive)

in your expression, it is FLAG instead Flag

FTE chart:

sum(ALLOC_HRS)/sum( aggr(max(MONTH_CAP),FISCAL_MONTH_YEAR,FLAG Flag))

Re: Sum( aggr(max())) Expression in Combo chart

sasiparupudi1 — Wed, 29 Jul 2015 10:25:32 GMT

as mentioned in the post before, your "Flag" field is not the same in your expression

FTE chart: sum(ALLOC_HRS)/sum( aggr(max(MONTH_CAP),FISCAL_MONTH_YEAR,Flag))

If you got your answer,please close this thread by marking the correct one

Sasi

Re: Sum( aggr(max())) Expression in Combo chart

cbaqir — Wed, 29 Jul 2015 14:47:31 GMT

Thank you for that (duh). That did fix the issue in my sample app. Unfortunately, this does not solve the issue in my real dashboard.

This is the expression in my FTE chart in the real dashboard for Allocated (not working): =(Sum({$} ALLOC_HRS))/sum( aggr(max(MONTH_CAP), FISCAL_MONTH_YEAR ,FLAG_PTO))

Working:

Actual FTE: =(Sum({$<TASK_NAME-={'PTO'}>} ACT_HRS))/sum( aggr(max(MONTH_CAP),FISCAL_MONTH_YEAR, FLAG_PTO))

Actual PTO: =Sum({$<TASK_NAME={'PTO'}>} ACT_HRS)/sum( aggr(max(MONTH_CAP),FISCAL_MONTH_YEAR, FLAG_PTO))

Capacity: SUM (ADJ_CAP)/sum( aggr(max(MONTH_CAP),FISCAL_MONTH_YEAR, FLAG_PTO))

Dimensions:

=date(FISCAL_MONTH_YEAR, 'YYYY-MMM')

=alt(FLAG_PTO,0)

This is the expression (that works) in my hours chart: =Sum([ALLOC_HRS])

There must be another reason...

Re: Sum( aggr(max())) Expression in Combo chart

settu_periasamy — Wed, 29 Jul 2015 14:53:55 GMT

Hi,

Just testing purpose can you remove {$} from sum expression

Try like

=(Sum({$}ALLOC_HRS))/sum( aggr(max(MONTH_CAP), FISCAL_MONTH_YEAR ,FLAG_PTO))

Edit:

=Sum(ALLOC_HRS)/sum( aggr(max(MONTH_CAP), FISCAL_MONTH_YEAR ,FLAG_PTO))