topic Re: Straight table > total in QlikView

Straight table > total

Fri, 20 Jul 2012 08:35:32 GMT

Hello QVer,

I have a straight table

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

Fri, 20 Jul 2012 08:42:25 GMT

check properties:

Fri, 20 Jul 2012 09:28:10 GMT

Thank you.

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

What's wrong? See example qvw attached.

dj_skbs

Fri, 20 Jul 2012 09:52:46 GMT

it should be expression:

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

=sum(FAKA*FAKB/FAKB)

brenner_martina — Fri, 20 Jul 2012 09:59:29 GMT

Hi, dj_skbs,

that's so easy, your expression must be:

Sum(FAKA*FAKB)/Sum(FAKB)

Greetings from Munich, Germany

Martina