Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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.

How can this be calculated in the backend?

But it doesn't work. Can u help?

Thank you!

1 Solution

Accepted Solutions

Re: Calculation of growth

Try this script:

Table:

LOAD * INLINE [

    Group, Timestamp, Anzahl_Tagessumme

    A, 12:00, 5

    A, 13:00, 10

    A, 14:00, 15

    A, 15:00, 25

];

FinalTable:

LOAD *,

  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
lakshmikandh
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

Re: Calculation of growth

Try this script:

Table:

LOAD * INLINE [

    Group, Timestamp, Anzahl_Tagessumme

    A, 12:00, 5

    A, 13:00, 10

    A, 14:00, 15

    A, 15:00, 25

];

FinalTable:

LOAD *,

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

Resident Table

Order By Group, Timestamp;

DROP Table Table;

florentina_doga
Contributor III

Re: Calculation of growth

try this script

aa:

load *,

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];       

Community Browser