QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
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.

How can this be calculated in the backend?

But it doesn't work. Can u help?

Thank you!

1 Solution

Accepted Solutions
MVP

Re: Calculation of growth

Try this script:

Table:

Group, Timestamp, Anzahl_Tagessumme

A, 12:00, 5

A, 13:00, 10

A, 14:00, 15

A, 15:00, 25

];

FinalTable:

If(Group = Previous(Group), RangeSum(Anzahl_Tagessumme, -Previous(Anzahl_Tagessumme)), Anzahl_Tagessumme) as Growth

Resident Table

Order By Group, Timestamp;

DROP Table Table;

3 Replies
Valued Contributor II

Re: Calculation of growth

Try using Peek/Previous functions, Peek() vs Previous() – When to Use Each

and for Grouping use Aggr() function

MVP

Re: Calculation of growth

Try this script:

Table:

Group, Timestamp, Anzahl_Tagessumme

A, 12:00, 5

A, 13:00, 10

A, 14:00, 15

A, 15:00, 25

];

FinalTable:

If(Group = Previous(Group), RangeSum(Anzahl_Tagessumme, -Previous(Anzahl_Tagessumme)), Anzahl_Tagessumme) as Growth

Resident Table

Order By Group, Timestamp;

DROP Table Table;

Contributor III

Re: Calculation of growth

try this script

aa:

if(Group=Previous(Group),Anzahl_Tagessumme-Previous(peek('growth')),Anzahl_Tagessumme) as growth;

load * inline [Group,    Timestamp,    Anzahl_Tagessumme

A, 12:00, 5

A, 13:00, 10

A,    14:00,    15

A,    15:00,    25

B

B];