topic calculated dimension in QlikView https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/474597#M480129 <HTML><HEAD></HEAD><BODY><P>friends,</P><P></P><P></P><P>I have calculated a horizontal dimension and I need to insert some values ​​in the table.</P><P></P><P>See the attached example.</P><P></P><P>Thank!</P></BODY></HTML> Wed, 11 Dec 2013 19:29:44 GMT 2013-12-11T19:29:44Z calculated dimension https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/474597#M480129 <HTML><HEAD></HEAD><BODY><P>friends,</P><P></P><P></P><P>I have calculated a horizontal dimension and I need to insert some values ​​in the table.</P><P></P><P>See the attached example.</P><P></P><P>Thank!</P></BODY></HTML> Wed, 11 Dec 2013 19:29:44 GMT https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/474597#M480129 2013-12-11T19:29:44Z Re: calculated dimension https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/474598#M480130 <HTML><HEAD></HEAD><BODY><P>Please find attached. I've included an extra table that uses the years as a dimension instead of using all hard-coded dimensions. That might be better than using multiple if statements, which may become cumbersome over time.</P><P></P><P>Also, i<SPAN style="font-size: 10pt; line-height: 1.5em;">nstead of using a calculated dimension for the values, I used an expression instead under its corresponding column.</SPAN></P><P></P><P>Hope this helps!</P></BODY></HTML> Wed, 11 Dec 2013 20:32:18 GMT https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/474598#M480130 jerem1234 2013-12-11T20:32:18Z Re: Re: calculated dimension https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/474599#M480131 <HTML><HEAD></HEAD><BODY><P>Examente not what I need.</P><P>I need a column called Var appears on the same line as the Volume (Tons)</P><P></P><P></P><P>See the attached image.</P><P></P><P></P><P><IMG alt="Example.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/50356_Example.png" /></P></BODY></HTML> Thu, 12 Dec 2013 13:33:19 GMT https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/474599#M480131 2013-12-12T13:33:19Z Re: Re: Re: calculated dimension https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/474600#M480132 <HTML><HEAD></HEAD><BODY><P>Here, I had to add one small table to your script. But instead of using calculated dimensions, I flipped it and turned the expressions into a dimensions. This allowed me to create those arrows in your chart as you desired. Please find attached.</P><P></P><P>Hope this helps!</P></BODY></HTML> Thu, 12 Dec 2013 15:10:13 GMT https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/474600#M480132 jerem1234 2013-12-12T15:10:13Z Re: Re: Re: calculated dimension https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/474601#M480133 <HTML><HEAD></HEAD><BODY><P>Excellent!</P><P></P><P>That's exactly what I wanted ...</P><P></P><P>Thank!</P></BODY></HTML> Mon, 16 Dec 2013 11:57:24 GMT https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/474601#M480133 2013-12-16T11:57:24Z