topic Re: expression in script - Meaning in QlikView

expression in script - Meaning

qlikviewwizard — Fri, 20 Nov 2020 18:02:30 GMT

Hi All,

What is the meaning of the expression in script?

Thanks in advance.

if(KEY = previous(KEY), Rangesum(Quantity, peek(CumulSales)), Quantity) as CumulSales,

Re: expression in script - Meaning

jagan — Mon, 06 Jul 2015 03:52:54 GMT

Hi,

Previous() will return the value of the given column in the previous row, in the script we are calculating the Cumulative sales based on the key.

If previous key value and the current key value is same then we are doing the sum of those values, otherwise we are starting the calculation again with the Current Quantity.

Hope this helps you.

Regards,

Jagan.

Re: expression in script - Meaning

jagan — Mon, 06 Jul 2015 03:57:12 GMT

Hi,

Check with below example

KEY , Quantity

1, 10

1, 20

1, 15

2, 5

2, 4

LOAD

If(KEY = previous(KEY), Rangesum(Quantity, peek(CumulSales)), Quantity) as CumulSales

FROM DataSource

ORDER BY KEY;

The output of above script

KEY , Quantity, CumulSales

1, 10, 10

1, 20, 30 (10 +20) (Since previous key is 1 = Current key 1)

1, 15, 45 (30 + 15) (Since previous key is 1 = Current key 1) Peek(CumuSales) = 30

2, 5, 5 (5) (Here the Previous Key is 1 <> Current Key 2) So gettting only current quantity.

2, 4, 9 (5+ 4) (Since previous key is 2 = Current key 2) Peek(CumuSales) = 5

Hope this helps you.

Regards,

Jagan.

Re: expression in script - Meaning

qlikviewwizard — Mon, 06 Jul 2015 04:31:13 GMT

Hi jagan,

I got it. Thank you so much for the detailed explanation.