Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Calculation of growth

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

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

Re: Calculation of growth

Without sorting you have to calculate it at back end.

MVP
MVP

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)