topic Need help in Calculated Dimension in QlikView https://community.qlik.com/t5/QlikView/Need-help-in-Calculated-Dimension/m-p/1216553#M867076 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I facing an issue to create a calculated dimension, i need to show <STRONG>forecast-Plan</STRONG> and <STRONG>forecast- Actual</STRONG> value as separate dimension in the chart.</P><P></P><P>Forecast is nothing but 1+11 F,2+10 F ,3+09 values</P><P></P><P>Please find attached pic as reference.</P><P></P><P><IMG __jive_id="145811" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/145811_Capture.PNG" style="height: 144px; width: 620px;" /></P><P>Above is the object i have created along with this i need other dimension as:</P><P></P><P>Forecast-Plan&nbsp; &amp; <SPAN style="font-size: 10pt;">Forecast-Actuals</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Forecast-Plan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -40&nbsp; for Jan month(Formula-(1+11 F - Plan i.e 10-50=-40)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="font-size: 10pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;"> -8&nbsp; for Feb month(Formula-(2+10 F - Plan i.e 21-29=-8)</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">same way for remaining as well till December month</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Here is sample file and qvw please find .</SPAN><SPAN style="font-size: 13.3333px;"> </SPAN><SPAN style="font-size: 10pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Need help in Calculated Dimension https://community.qlik.com/t5/QlikView/Need-help-in-Calculated-Dimension/m-p/1216553#M867076 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I facing an issue to create a calculated dimension, i need to show <STRONG>forecast-Plan</STRONG> and <STRONG>forecast- Actual</STRONG> value as separate dimension in the chart.</P><P></P><P>Forecast is nothing but 1+11 F,2+10 F ,3+09 values</P><P></P><P>Please find attached pic as reference.</P><P></P><P><IMG __jive_id="145811" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/145811_Capture.PNG" style="height: 144px; width: 620px;" /></P><P>Above is the object i have created along with this i need other dimension as:</P><P></P><P>Forecast-Plan&nbsp; &amp; <SPAN style="font-size: 10pt;">Forecast-Actuals</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Forecast-Plan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -40&nbsp; for Jan month(Formula-(1+11 F - Plan i.e 10-50=-40)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="font-size: 10pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;"> -8&nbsp; for Feb month(Formula-(2+10 F - Plan i.e 21-29=-8)</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">same way for remaining as well till December month</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Here is sample file and qvw please find .</SPAN><SPAN style="font-size: 13.3333px;"> </SPAN><SPAN style="font-size: 10pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Need-help-in-Calculated-Dimension/m-p/1216553#M867076 2020-11-25T16:16:04Z