Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
robert2012
Contributor III
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
MK_QSL
MVP
MVP

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

effinty2112
Master
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

robert2012
Contributor III
Contributor III
Author

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

robert2012
Contributor III
Contributor III
Author

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

MK_QSL
MVP
MVP

Without sorting you have to calculate it at back end.

sunny_talwar

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)