topic Budget values not coming in Pivot in QlikView https://community.qlik.com/t5/QlikView/Budget-values-not-coming-in-Pivot/m-p/1546238#M746426 <P>Hi,</P><P>I am new to <STRONG>QlikSense</STRONG> and need to integrate budget with actual.</P><P>Actually I have been given Budget and Actuals Branchwise.</P><P>Budget is given on Yearly basis(Fiscal Year)&nbsp; and Actual is present in data on daily basis.</P><P>Firstly, I&nbsp; need to show data Quaterwise Budget V/s Actual.</P><P>Secondly, If actual for particular branch is not present then atleast its budget should be displayed(like Goa and mumbai in below example).When I am trying to display that the whole branch where Actual is not present is not been shown.</P><P>Expected Output:</P><TABLE><TBODY><TR><TD>Branch</TD><TD>Q1</TD><TD>Q2</TD><TD>Q3</TD><TD>Q4</TD></TR><TR><TD>&nbsp;</TD><TD>Budget</TD><TD>Actuals</TD><TD>Budget</TD><TD>Actuals</TD><TD>Budget</TD><TD>Actuals</TD><TD>Budget</TD><TD>Actuals</TD></TR><TR><TD>goa</TD><TD>125</TD><TD>&nbsp;</TD><TD>125</TD><TD>&nbsp;</TD><TD>125</TD><TD>&nbsp;</TD><TD>125</TD><TD>&nbsp;</TD></TR><TR><TD>gujrat</TD><TD>150</TD><TD>122</TD><TD>150</TD><TD>112</TD><TD>150</TD><TD>78</TD><TD>150</TD><TD>76</TD></TR><TR><TD>maharashtra</TD><TD>175</TD><TD>150</TD><TD>175</TD><TD>125</TD><TD>175</TD><TD>98</TD><TD>175</TD><TD>74</TD></TR><TR><TD>delhi</TD><TD>200</TD><TD>88</TD><TD>200</TD><TD>91</TD><TD>200</TD><TD>79</TD><TD>200</TD><TD>88</TD></TR><TR><TD>lucknow</TD><TD>225</TD><TD>90</TD><TD>225</TD><TD>75</TD><TD>225</TD><TD>96</TD><TD>225</TD><TD>135</TD></TR><TR><TD>nagpur</TD><TD>237.5</TD><TD>45</TD><TD>237.5</TD><TD>63</TD><TD>237.5</TD><TD>135</TD><TD>237.5</TD><TD>145</TD></TR><TR><TD>mumbai</TD><TD>250</TD><TD>&nbsp;</TD><TD>250</TD><TD>&nbsp;</TD><TD>250</TD><TD>&nbsp;</TD><TD>250</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;Thanks in advance</P> Sat, 16 Nov 2024 04:24:34 GMT saurabha 2024-11-16T04:24:34Z Budget values not coming in Pivot https://community.qlik.com/t5/QlikView/Budget-values-not-coming-in-Pivot/m-p/1546238#M746426 <P>Hi,</P><P>I am new to <STRONG>QlikSense</STRONG> and need to integrate budget with actual.</P><P>Actually I have been given Budget and Actuals Branchwise.</P><P>Budget is given on Yearly basis(Fiscal Year)&nbsp; and Actual is present in data on daily basis.</P><P>Firstly, I&nbsp; need to show data Quaterwise Budget V/s Actual.</P><P>Secondly, If actual for particular branch is not present then atleast its budget should be displayed(like Goa and mumbai in below example).When I am trying to display that the whole branch where Actual is not present is not been shown.</P><P>Expected Output:</P><TABLE><TBODY><TR><TD>Branch</TD><TD>Q1</TD><TD>Q2</TD><TD>Q3</TD><TD>Q4</TD></TR><TR><TD>&nbsp;</TD><TD>Budget</TD><TD>Actuals</TD><TD>Budget</TD><TD>Actuals</TD><TD>Budget</TD><TD>Actuals</TD><TD>Budget</TD><TD>Actuals</TD></TR><TR><TD>goa</TD><TD>125</TD><TD>&nbsp;</TD><TD>125</TD><TD>&nbsp;</TD><TD>125</TD><TD>&nbsp;</TD><TD>125</TD><TD>&nbsp;</TD></TR><TR><TD>gujrat</TD><TD>150</TD><TD>122</TD><TD>150</TD><TD>112</TD><TD>150</TD><TD>78</TD><TD>150</TD><TD>76</TD></TR><TR><TD>maharashtra</TD><TD>175</TD><TD>150</TD><TD>175</TD><TD>125</TD><TD>175</TD><TD>98</TD><TD>175</TD><TD>74</TD></TR><TR><TD>delhi</TD><TD>200</TD><TD>88</TD><TD>200</TD><TD>91</TD><TD>200</TD><TD>79</TD><TD>200</TD><TD>88</TD></TR><TR><TD>lucknow</TD><TD>225</TD><TD>90</TD><TD>225</TD><TD>75</TD><TD>225</TD><TD>96</TD><TD>225</TD><TD>135</TD></TR><TR><TD>nagpur</TD><TD>237.5</TD><TD>45</TD><TD>237.5</TD><TD>63</TD><TD>237.5</TD><TD>135</TD><TD>237.5</TD><TD>145</TD></TR><TR><TD>mumbai</TD><TD>250</TD><TD>&nbsp;</TD><TD>250</TD><TD>&nbsp;</TD><TD>250</TD><TD>&nbsp;</TD><TD>250</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;Thanks in advance</P> Sat, 16 Nov 2024 04:24:34 GMT https://community.qlik.com/t5/QlikView/Budget-values-not-coming-in-Pivot/m-p/1546238#M746426 saurabha 2024-11-16T04:24:34Z