topic Re: Load Script: Add a total column in QlikView

Load Script: Add a total column

Sat, 20 Jul 2013 13:59:54 GMT

Hi,

I am wondering if someone can point me to the right direction here.

Suppose I have Table1 below

Table1:

Col1 Col2

a 1

b 2

c 3

d 4

I would like to have a load script t that load Table1 and create Table2 (which add a total column)

Table2:

Col1 Col2 Total

a 1 10

b 2 10

c 3 10

d 4 10

For reason that I won't get into it, I need to use a load script. Can someone help me out, I am just not sure how to accomplish this in QV. Thank you.

Re: Load Script: Add a total column

nagaiank — Sat, 20 Jul 2013 14:39:17 GMT

Try the following script:

Table2:

NoConcatenate

Load *, 10 as Total Resident Table1;

Re: Load Script: Add a total column

Sat, 20 Jul 2013 14:43:45 GMT

Unfortunately, I need the total column to be dynamic. For example, Table1 can have 100 or 1000 or 10000 rows, and I need to be able to calculate that dynamically.

Sent from Samsung Mobile

Re: Load Script: Add a total column

Gysbert_Wassenaar — Sat, 20 Jul 2013 16:49:33 GMT

Table1:

load Col1, Col2

from ...somewhere...;

join(Table1)

load sum(Col2)

resident Table1;

Re: Load Script: Add a total column

Sun, 21 Jul 2013 04:17:37 GMT

Works great, thank you Gysbert.

A quick question (hope you don't mind), what if I need an accummulative sum column, how would I accomplish that? Thank you..

Re: Load Script: Add a total column

Gysbert_Wassenaar — Sun, 21 Jul 2013 08:34:47 GMT

Table1:

load Col1, Col2, rangesum(peek('Cumulative',Col2) as Cumulative

from ...somewhere...;

Re: Load Script: Add a total column

Sun, 21 Jul 2013 11:27:46 GMT

Thank you.