Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sub total pivot table

Hi everyone,

I am a beginner. I would like to get something like this :

Dim 1    DIm2   Exp1     Exp2

A          j            2             14

A         d             5            14

A         e             7            14

B         t              1             5

B         r              4            5

I don't know how to get the Exp2. I would like to do a sum without taking into account the second dimension.

I tried an expression like  sum ({<Dim2=>} value)  but this doesnt work.

thank you for your help

1 Solution

Accepted Solutions
Nicole-Smith

sum(TOTAL <Dim1> value)

View solution in original post

5 Replies
Nicole-Smith

sum(TOTAL <Dim1> value)

View solution in original post

alexandros17

Try this

sum(aggr(sum(value), Dim1))

MK_QSL
MVP
MVP

Script side...

Data:

Load * Inline

[

  Dim1, Dim2, Exp1   

  A,     j,      2  

  A,     d,      5

  A,     e,      7

  B,     t,      1

  B,     r,      4

];

Left Join (Data)

Load

  Dim1,

  SUM(Exp1) as Exp2

Resident Data

Group By Dim1;

=====================

You expression Exp1 could be Sum(Sales)

Not applicable
Author

Thank you Nicole, it works well.

Now, I would like to have a 3rd expression which is exp1/exp2 (so the percentage).  I did the expression exp1 / the expression exp 2 and it works but I'm just wondering if there was another way to do it (a shorter or simpler way) ?

Thanks again.

MK_QSL
MVP
MVP

Column(1)/Column(2)