Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

shane_spencer
Valued Contributor

Straight Table - new row as sum of some others

I've got this chart/table (see below). It's very simple expression to get Final value is: sum(AMT_NET_TAXREP_clo_1*VATFORM_POLARITY)

What I need to do is create a new row where the Ref: is 6 that is the sum of row (Ref) 1, 2, (3 if it exists), 4 and 5. Is that possible?

n.b. I'd also like to give it the Description: Total sales (amount SAR)

BREF.PNG

i.e.

6Total sales (amount SAR)20,543,502.70

I will also need to do the same for rows 7-11 to create row 12 but I guess the solution will be the same.

Tags (2)
1 Solution

Accepted Solutions

Re: Straight Table - new row as sum of some others

Is this what you wanted?

Capture.PNG

Added a new table in the script by doing a binary load... also had to remove your hidden script to be able to run the binary load.

View solution in original post

2 Replies

Re: Straight Table - new row as sum of some others

Is this what you wanted?

Capture.PNG

Added a new table in the script by doing a binary load... also had to remove your hidden script to be able to run the binary load.

View solution in original post

shane_spencer
Valued Contributor

Re: Straight Table - new row as sum of some others

That's great sunny. It was easy enough to expand to work out 12 too.