Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

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

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)

vs

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

5 Replies
Highlighted
Specialist
Specialist

No one?

Highlighted

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))

Highlighted
Master III
Master III

Hi

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

Highlighted
Specialist
Specialist

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...

Highlighted

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))