topic help with aggregation and dynamic dimensions in QlikView https://community.qlik.com/t5/QlikView/help-with-aggregation-and-dynamic-dimensions/m-p/164358#M37085 <HTML><HEAD></HEAD><BODY><P>I've never heard about such notation, but try this:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />=SUM({1&lt;Dokumenttyp={"2"}&gt;} Grundlage)</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Tue, 17 Aug 2010 14:10:30 GMT 2010-08-17T14:10:30Z help with aggregation and dynamic dimensions https://community.qlik.com/t5/QlikView/help-with-aggregation-and-dynamic-dimensions/m-p/164357#M37084 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>in my table there are documents with different doctypes. In my diagram i want to show only the the documents in wich the documenttype is a certain one. i don`t know if i should use a dynamic dimension or a formula!? i tried to type this in my formula but it doesn`t work...</P><P>=SUM({1&lt;VerkaufsdokumentKopf.Dokumenttyp={'2'}&gt;} VerkaufsdokumentKopf.Grundlage)</P><P>VerkaufsdokumentKopf.Dokumenttyp is a small int field what is wrong in my expression? or what is a solution for my problem?</P><P></P><P></P></BODY></HTML> Tue, 17 Aug 2010 13:35:53 GMT https://community.qlik.com/t5/QlikView/help-with-aggregation-and-dynamic-dimensions/m-p/164357#M37084 2010-08-17T13:35:53Z help with aggregation and dynamic dimensions https://community.qlik.com/t5/QlikView/help-with-aggregation-and-dynamic-dimensions/m-p/164358#M37085 <HTML><HEAD></HEAD><BODY><P>I've never heard about such notation, but try this:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />=SUM({1&lt;Dokumenttyp={"2"}&gt;} Grundlage)</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Tue, 17 Aug 2010 14:10:30 GMT https://community.qlik.com/t5/QlikView/help-with-aggregation-and-dynamic-dimensions/m-p/164358#M37085 2010-08-17T14:10:30Z help with aggregation and dynamic dimensions https://community.qlik.com/t5/QlikView/help-with-aggregation-and-dynamic-dimensions/m-p/164359#M37086 <HTML><HEAD></HEAD><BODY><P>thx for your replys... no i found out that my problem is a different one my concatenate doesn`t work right. i have 2 tables one with fields x y z and the other with u and v now i load them in this way</P><P>newtable:</P><P>load x as a, y as b, z as c from table1;</P><P>concatenate</P><P>load u as a ,v as lol from table2;</P><P>my problem s that in newtable there are only the values ou of table1 the values of table2 are missing</P><P></P></BODY></HTML> Tue, 17 Aug 2010 14:46:23 GMT https://community.qlik.com/t5/QlikView/help-with-aggregation-and-dynamic-dimensions/m-p/164359#M37086 2010-08-17T14:46:23Z help with aggregation and dynamic dimensions https://community.qlik.com/t5/QlikView/help-with-aggregation-and-dynamic-dimensions/m-p/164360#M37087 <HTML><HEAD></HEAD><BODY><P>It works fine on my side. Take a look at attachment.</P></BODY></HTML> Tue, 17 Aug 2010 15:03:27 GMT https://community.qlik.com/t5/QlikView/help-with-aggregation-and-dynamic-dimensions/m-p/164360#M37087 2010-08-17T15:03:27Z help with aggregation and dynamic dimensions https://community.qlik.com/t5/QlikView/help-with-aggregation-and-dynamic-dimensions/m-p/164361#M37088 <HTML><HEAD></HEAD><BODY><P>i had qualified the fields...=) i know i`m a idiot</P></BODY></HTML> Tue, 17 Aug 2010 15:18:57 GMT https://community.qlik.com/t5/QlikView/help-with-aggregation-and-dynamic-dimensions/m-p/164361#M37088 2010-08-17T15:18:57Z help with aggregation and dynamic dimensions https://community.qlik.com/t5/QlikView/help-with-aggregation-and-dynamic-dimensions/m-p/164362#M37089 <HTML><HEAD></HEAD><BODY><P>Nobody is protected from this. And it happens with the best of us <IMG alt="Wink" src="http://community.qlik.com/emoticons/emotion-5.gif" /></P></BODY></HTML> Tue, 17 Aug 2010 15:41:37 GMT https://community.qlik.com/t5/QlikView/help-with-aggregation-and-dynamic-dimensions/m-p/164362#M37089 2010-08-17T15:41:37Z