Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
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.