topic Re: full set of dimensions with a complex formula in QlikView https://community.qlik.com/t5/QlikView/full-set-of-dimensions-with-a-complex-formula/m-p/121208#M509474 <HTML><HEAD></HEAD><BODY><P>This</P><P></P><P><STRONG>=Sum(<SPAN style="color: #ff0000;">{1}</SPAN> #HNR_Istbestand)/Sum({<SPAN style="color: #ff0000;">1</SPAN>&lt;VK.Tätigkeitsliteral = {'Technik'}&gt;}[VK.VK-Wert2])</STRONG></P></BODY></HTML> Thu, 08 Nov 2018 15:20:04 GMT sunny_talwar 2018-11-08T15:20:04Z full set of dimensions with a complex formula https://community.qlik.com/t5/QlikView/full-set-of-dimensions-with-a-complex-formula/m-p/121207#M509473 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i would like to create a bar chart with fixed values of all dimensions just like sum({1} amount). </P><P></P><P>But how do I do that with a more complex formula? </P><P></P><P>=sum(#HNR_Istbestand) /sum({&lt;VK.Tätigkeitsliteral={'Technik'}&gt;}[VK.VK-Wert2]) </P><P></P><P>Greetings</P><P>Mario</P></BODY></HTML> Thu, 08 Nov 2018 15:18:25 GMT https://community.qlik.com/t5/QlikView/full-set-of-dimensions-with-a-complex-formula/m-p/121207#M509473 socura 2018-11-08T15:18:25Z Re: full set of dimensions with a complex formula https://community.qlik.com/t5/QlikView/full-set-of-dimensions-with-a-complex-formula/m-p/121208#M509474 <HTML><HEAD></HEAD><BODY><P>This</P><P></P><P><STRONG>=Sum(<SPAN style="color: #ff0000;">{1}</SPAN> #HNR_Istbestand)/Sum({<SPAN style="color: #ff0000;">1</SPAN>&lt;VK.Tätigkeitsliteral = {'Technik'}&gt;}[VK.VK-Wert2])</STRONG></P></BODY></HTML> Thu, 08 Nov 2018 15:20:04 GMT https://community.qlik.com/t5/QlikView/full-set-of-dimensions-with-a-complex-formula/m-p/121208#M509474 sunny_talwar 2018-11-08T15:20:04Z Re: full set of dimensions with a complex formula https://community.qlik.com/t5/QlikView/full-set-of-dimensions-with-a-complex-formula/m-p/121209#M509475 <HTML><HEAD></HEAD><BODY><P>I had to know that. One of these days...;-)</P><P>Thank You very much!</P></BODY></HTML> Thu, 08 Nov 2018 15:23:30 GMT https://community.qlik.com/t5/QlikView/full-set-of-dimensions-with-a-complex-formula/m-p/121209#M509475 socura 2018-11-08T15:23:30Z