# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for
Did you mean:
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

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

Master

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

Contributor III
Author

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

Contributor III
Author

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

MVP

Without sorting you have to calculate it at back end.

MVP

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)

Community Browser