Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Straight table > total

Hello QVer,

I have a straight table

ABCDEF
IDFAKAFAKBFAKA*FAKBFAKA*FAKB / FAKBWANTED
TOTAL-9152,1070,2016,9 (=152,1/9)
ID124,40124,4024,4024,40
ID219,80359,4019,8019,80
ID314,10456,4014,1014,10
ID411,90111,9011,9011,90

 

and our users want the result of "field D/field C" in all rows - incl. total -; and not "sum of rows" as you see in

in field=E.

I did a lot of exercises to solve that but with no successfull outcome.

Do you see a workable solution? Is it possible with straight tabel?

Thank you an Greetings

dj_skbs

See also picture.

1 Solution

Accepted Solutions
brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi, dj_skbs,

that's so easy, your expression must be:

Sum(FAKA*FAKB)/Sum(FAKB)

Greetings from Munich, Germany

Martina

View solution in original post

4 Replies
Not applicable
Author

check properties:

Not applicable
Author

Thank you.

I tried the proposal "Pari Pari" gave me but I got an empty total cell (field E) doing so:

ABCDE
IDFAKAFAKBFAKA*FAKBFAKA*FAKB/FAKB
70,29152,1-
ID124,40124,424,4
ID219,80359,419,8
ID314,10456,414,1
ID411,90111,911,9

What's wrong? See example qvw attached.

dj_skbs

Not applicable
Author

it should be expression:

=sum(FAKA)*sum(FAKB)/sum(FAKB)

or

=sum(FAKA*FAKB/FAKB)

brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi, dj_skbs,

that's so easy, your expression must be:

Sum(FAKA*FAKB)/Sum(FAKB)

Greetings from Munich, Germany

Martina