Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Not applicable

How to get Sum of Max values in a diagram

Dear all,

I have a problem summing up the Max values over 2 dimensions.

What I thought to be basic seems to be quite tricky:

Two data sources ("Meldestelle") send usage data should ("Soll")/is ("Ist") for two services "Derivat"

I create a diagram with

  • Bars abs."should" accumulated ->ok
  • Bars abs."is" accumulated ->ok
  • Line relative "should" ->problem
  • Line relative "is" ->problem

For the latter 2 I tried

=sum(TIF_TABLE.accum_soll_h) / sum(Max(TOTAL TIF_TABLE.accum_soll_h))

Or alike but the divisor seems to evaluate wrong:

I would expect sum(Max(TOTAL TIF_TABLE.accum_soll_h)) to give me the max of - in this case the sum(TIF_TABLE.accum_soll_h).

All works out, when selecting ONE "Meldestelle" and ONE Derivat:

Over multiple it fails…

I also tried with aggr - like

sum(Aggr(Max(TIF_TABLE.accum_soll_h),TIF_TABLE.%MeldeStelle_Key ))

But results look even more strange…

Someone can help, please?

Thanks Oliver

1 Solution

Accepted Solutions
MVP
MVP

Re: How to get Sum of Max values in a diagram

See if these work:

=Sum(TIF_TABLE.accum_soll_h) / Max(TOTAL Aggr(Sum(TIF_TABLE.accum_soll_h), TIF_TABLE.I_Stufe.MeilenStein_Woche))

=Sum(TIF_TABLE.accum_ist_h) / Max(TOTAL Aggr(Sum(TIF_TABLE.accum_ist_h), TIF_TABLE.I_Stufe.MeilenStein_Woche))

Capture.PNG

2 Replies
MVP
MVP

Re: How to get Sum of Max values in a diagram

See if these work:

=Sum(TIF_TABLE.accum_soll_h) / Max(TOTAL Aggr(Sum(TIF_TABLE.accum_soll_h), TIF_TABLE.I_Stufe.MeilenStein_Woche))

=Sum(TIF_TABLE.accum_ist_h) / Max(TOTAL Aggr(Sum(TIF_TABLE.accum_ist_h), TIF_TABLE.I_Stufe.MeilenStein_Woche))

Capture.PNG

Not applicable

Re: How to get Sum of Max values in a diagram

Hi Sunny,

thanks a lot - it took me several hours trying before I finally posted the question... You solved it! :-)

Have a nice weekend Oliver