topic Showing sums in different columns, dependent on certain value in QlikView

Showing sums in different columns, dependent on certain value

Thu, 10 Sep 2009 21:34:21 GMT

Hi,

I have the following tables:

No | Client | Amount | Kind
1 C1 5 a
2 C2 10 b
3 C1 8 a
4 C1 2 c

Kind | Code
a "60%"
b "80%"
c "100%"

With a Pivot I can show (for example):

Client | Code | Sum(Amount)
C1 "60%" 8+5=13
C1 "100%" 2

But I would like to show these Sums not in Rows but in Columns:

Client | "60%" | "80%" | "100%"
C1 13 0 2

Please, can anyone help?

Thank you very much,
Martin

Showing sums in different columns, dependent on certain value

Thu, 10 Sep 2009 21:45:30 GMT

just click and drag the column to the top of the rows. It will display column wise.

Showing sums in different columns, dependent on certain value

Thu, 10 Sep 2009 21:57:30 GMT

Hi Richy,

thank you for the quick response.

But I can not click and drag the column to the top. How can I do this?

I am using QlikView 7.52, is that the problem?

Is that described in the QV help? Topic?

Thanks again,
Martin

Showing sums in different columns, dependent on certain value

Thu, 10 Sep 2009 22:05:33 GMT

Oh, wait, now I got it.

I didn't have the right properties ("Presentation") in my Pivot.

I had activated "Show all layers" ("Alle Ebenen sichtbar" in german). And I had deactivated "Interactive Pivot".
After deactivating "Layers" and activating "Interactive" again I could drag like you said.

Thank you very much.
Martin