Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

robert2012
New Contributor III

Calculation of growth

Hi all,

I have the following table:

GroupTimestampAnzahl_Tagessumme?? growth

A

12:00

55
A13:0010

5

A14:00155
A15:002510
B
B

I only have the first two columns => I don't have the third one (?? growth).

Now I want to show not the sum in a diagramm - but the growth.

I tried the follwing in the diagramm:

(sum (Anzahl_Tagessumme))-((sum (Anzahl_Tagessumme)-MaxString(Anzahl_Tagessumme)))

But it doesn't work. Can u help?

Thank you!

6 Replies
MVP
MVP

Re: Calculation of growth

IF(RowNo(TOTAL) = 1, SUM(Anzahl_Tagessumme), SUM(Anzahl_Tagessumme)-Above(SUM(Anzahl_Tagessumme)))

effinty2112
Honored Contributor

Re: Calculation of growth

Hi Robert,

                    The Above function is what you need:

Timestamp sum(Anzahl_Tagessumme) sum(Anzahl_Tagessumme)- above(sum(Anzahl_Tagessumme))
55  
12:005 
13:00105
14:00155
15:002510

Cheers

Andrew

robert2012
New Contributor III

Re: Calculation of growth

the table is not sorted and there are two different categories. I will add in the table.

robert2012
New Contributor III

Re: Calculation of growth

the table is not sorted and there are two different categories. I will add in the table.

MVP
MVP

Re: Calculation of growth

Without sorting you have to calculate it at back end.

Re: Calculation of growth

How about using a Aggr() for sorting here? Hopefully the Timestamp is sorted in ascending order in the script. If it is not, then it will be an issue

Aggr(

If(RowNo() = 1, SUM(Anzahl_Tagessumme), SUM(Anzahl_Tagessumme)-Above(SUM(Anzahl_Tagessumme)))

,Group, Timestamp)