topic Re: Summe Pivot Tabelle in QlikView https://community.qlik.com/t5/QlikView/Summe-Pivot-Tabelle/m-p/783749#M471945 <HTML><HEAD></HEAD><BODY><P>Could you send the document please?</P></BODY></HTML> Wed, 11 Feb 2015 10:02:38 GMT alexandros17 2015-02-11T10:02:38Z Summe Pivot Tabelle https://community.qlik.com/t5/QlikView/Summe-Pivot-Tabelle/m-p/783748#M471944 <HTML><HEAD></HEAD><BODY><P>Hallo,</P><P></P><P>ich benutze eine Pivottabelle in der bereits 3 Spalten sind. Nun würde ich gerne die 3.Spalte, welche die 2. und 1. Spalte über column(1) * column(2) summiert und WERT heißt in der dritten Spalten in einer neue Formel verwende. Ich erhalte aber immer 0! Warum?</P><P>DIe Formel ist ganz einfach sum(WERT)...! WERT ist die Beschriftung der 3. Spalte...</P><P></P><P>Viele Grüße</P></BODY></HTML> Wed, 11 Feb 2015 09:59:21 GMT https://community.qlik.com/t5/QlikView/Summe-Pivot-Tabelle/m-p/783748#M471944 2015-02-11T09:59:21Z Re: Summe Pivot Tabelle https://community.qlik.com/t5/QlikView/Summe-Pivot-Tabelle/m-p/783749#M471945 <HTML><HEAD></HEAD><BODY><P>Could you send the document please?</P></BODY></HTML> Wed, 11 Feb 2015 10:02:38 GMT https://community.qlik.com/t5/QlikView/Summe-Pivot-Tabelle/m-p/783749#M471945 alexandros17 2015-02-11T10:02:38Z Re: Summe Pivot Tabelle https://community.qlik.com/t5/QlikView/Summe-Pivot-Tabelle/m-p/783750#M471946 <HTML><HEAD></HEAD><BODY><P>A sample qvw will be useful.</P><P></P><P>Marc.</P></BODY></HTML> Wed, 11 Feb 2015 10:02:42 GMT https://community.qlik.com/t5/QlikView/Summe-Pivot-Tabelle/m-p/783750#M471946 Anonymous 2015-02-11T10:02:42Z Re: Summe Pivot Tabelle https://community.qlik.com/t5/QlikView/Summe-Pivot-Tabelle/m-p/783751#M471947 <HTML><HEAD></HEAD><BODY><P>Here is my example...</P></BODY></HTML> Wed, 11 Feb 2015 10:13:36 GMT https://community.qlik.com/t5/QlikView/Summe-Pivot-Tabelle/m-p/783751#M471947 2015-02-11T10:13:36Z Re: Summe Pivot Tabelle https://community.qlik.com/t5/QlikView/Summe-Pivot-Tabelle/m-p/783752#M471948 <HTML><HEAD></HEAD><BODY><P>Inside Sum function you have to add a field name, not a expression name. If you want to operate with an expression, just call it</P><P></P><P>Please find attached.</P><P></P><P>Marc.</P></BODY></HTML> Wed, 11 Feb 2015 10:21:55 GMT https://community.qlik.com/t5/QlikView/Summe-Pivot-Tabelle/m-p/783752#M471948 Anonymous 2015-02-11T10:21:55Z Re: Summe Pivot Tabelle https://community.qlik.com/t5/QlikView/Summe-Pivot-Tabelle/m-p/783753#M471949 <HTML><HEAD></HEAD><BODY><P>In the last column you do not need Sum(WERT), just write [WERT]</P></BODY></HTML> Wed, 11 Feb 2015 10:24:35 GMT https://community.qlik.com/t5/QlikView/Summe-Pivot-Tabelle/m-p/783753#M471949 alexandros17 2015-02-11T10:24:35Z Re: Summe Pivot Tabelle https://community.qlik.com/t5/QlikView/Summe-Pivot-Tabelle/m-p/783754#M471950 <HTML><HEAD></HEAD><BODY><P>Okay i was not spezific enough. In my real Report i have a set Analysis. Have a look at my file. This is my Problem.</P></BODY></HTML> Wed, 11 Feb 2015 10:35:25 GMT https://community.qlik.com/t5/QlikView/Summe-Pivot-Tabelle/m-p/783754#M471950 2015-02-11T10:35:25Z Re: Summe Pivot Tabelle https://community.qlik.com/t5/QlikView/Summe-Pivot-Tabelle/m-p/783755#M471951 <HTML><HEAD></HEAD><BODY><P>See attached.</P><P>Use field names instead of expression names inside the Sum function.</P><P></P><P>Hope it helps.</P><P></P><P>Marc.</P></BODY></HTML> Wed, 11 Feb 2015 10:43:45 GMT https://community.qlik.com/t5/QlikView/Summe-Pivot-Tabelle/m-p/783755#M471951 Anonymous 2015-02-11T10:43:45Z