topic Calculated Expression in Pivot table in QlikView https://community.qlik.com/t5/QlikView/Calculated-Expression-in-Pivot-table/m-p/865600#M302831 <HTML><HEAD></HEAD><BODY><P>Hi, guys!</P><P></P><P>I have a pivot as follows with the expression:IF(min(Month_name)&gt;=(vCurMonth),Sum(Sal*Bench_Data),Sum({&lt;Y={'2015'}&gt;}Fact_bench))-Sum(Budget)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="672"><TBODY><TR><TD class="xl63" height="17" width="98"> </TD><TD class="xl64" style="border-left: none;" width="98">Quarter</TD><TD class="xl76" width="121">Q1</TD><TD class="xl76" width="107">Q2</TD><TD class="xl65" width="115">Q3</TD><TD class="xl65" style="border-left: none;" width="133">Q4</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BG_bench</TD><TD class="xl67" style="border-left: none;">Rest</TD><TD class="xl65" style="border-top: none;">Rest of Budget 2015, USD</TD><TD class="xl65" style="border-top: none; border-left: none;">Bench 2015 vs Budget 2015, %</TD><TD class="xl65" style="border-top: none; border-left: none;">Rest of Budget 2015, USD</TD><TD class="xl65" style="border-top: none; border-left: none;">Rest of Budget 2015, USD</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BG1</TD><TD class="xl65" style="border-top: none; border-left: none;">-61640</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">-33,992</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">-82%</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">-95,706</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">-146,370</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BG2</TD><TD class="xl65" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">2,184</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">0%</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1,344</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1,512</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BG3</TD><TD class="xl65" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">10,296</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">0%</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6,336</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">7,128</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BG4</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">5,616</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">0%</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">3,456</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">3,888</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BG5</TD><TD class="xl65" style="border-top: none; border-left: none;">3</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">8,424</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">0%</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">5,184</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">5,832</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BG6</TD><TD class="xl65" style="border-top: none; border-left: none;">4</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">0</TD><TD class="xl71" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BG7</TD><TD class="xl65" style="border-top: none; border-left: none;">5</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">5,616</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">0%</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">3,456</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">3,888</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BG8</TD><TD class="xl65" style="border-top: none; border-left: none;">6</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">2,496</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">0%</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1,536</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1,728</TD></TR><TR><TD class="xl72" height="17" style="border-top: none;">Total</TD><TD class="xl73" style="border-top: none;"> </TD><TD align="right" class="xl74" style="border-top: none; border-left: none;">640</TD><TD align="right" class="xl75" style="border-top: none; border-left: none;">-1%</TD><TD align="right" class="xl74" style="border-top: none; border-left: none;">-74,394</TD><TD align="right" class="xl74" style="border-top: none; border-left: none;">-122,394</TD></TR></TBODY></TABLE><P></P><P></P><P>I want ot create a calculated dimesion with the rest of budget for the year: Aggr(IF(min(Month_name)&gt;=(vCurMonth),Sum(Sal*Bench_Data),Sum({&lt;Y={'2015'}&gt;}Fact_bench))-Sum(Budget),BG_bench)</P><P></P><P>But it doesnt work properly.</P><P></P><P>Any ideas?</P></BODY></HTML> Tue, 07 Apr 2015 09:45:26 GMT 2015-04-07T09:45:26Z Calculated Expression in Pivot table https://community.qlik.com/t5/QlikView/Calculated-Expression-in-Pivot-table/m-p/865600#M302831 <HTML><HEAD></HEAD><BODY><P>Hi, guys!</P><P></P><P>I have a pivot as follows with the expression:IF(min(Month_name)&gt;=(vCurMonth),Sum(Sal*Bench_Data),Sum({&lt;Y={'2015'}&gt;}Fact_bench))-Sum(Budget)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="672"><TBODY><TR><TD class="xl63" height="17" width="98"> </TD><TD class="xl64" style="border-left: none;" width="98">Quarter</TD><TD class="xl76" width="121">Q1</TD><TD class="xl76" width="107">Q2</TD><TD class="xl65" width="115">Q3</TD><TD class="xl65" style="border-left: none;" width="133">Q4</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BG_bench</TD><TD class="xl67" style="border-left: none;">Rest</TD><TD class="xl65" style="border-top: none;">Rest of Budget 2015, USD</TD><TD class="xl65" style="border-top: none; border-left: none;">Bench 2015 vs Budget 2015, %</TD><TD class="xl65" style="border-top: none; border-left: none;">Rest of Budget 2015, USD</TD><TD class="xl65" style="border-top: none; border-left: none;">Rest of Budget 2015, USD</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BG1</TD><TD class="xl65" style="border-top: none; border-left: none;">-61640</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">-33,992</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">-82%</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">-95,706</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">-146,370</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BG2</TD><TD class="xl65" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">2,184</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">0%</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1,344</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1,512</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BG3</TD><TD class="xl65" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">10,296</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">0%</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6,336</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">7,128</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BG4</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">5,616</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">0%</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">3,456</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">3,888</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BG5</TD><TD class="xl65" style="border-top: none; border-left: none;">3</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">8,424</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">0%</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">5,184</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">5,832</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BG6</TD><TD class="xl65" style="border-top: none; border-left: none;">4</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">0</TD><TD class="xl71" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BG7</TD><TD class="xl65" style="border-top: none; border-left: none;">5</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">5,616</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">0%</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">3,456</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">3,888</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BG8</TD><TD class="xl65" style="border-top: none; border-left: none;">6</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">2,496</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">0%</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1,536</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1,728</TD></TR><TR><TD class="xl72" height="17" style="border-top: none;">Total</TD><TD class="xl73" style="border-top: none;"> </TD><TD align="right" class="xl74" style="border-top: none; border-left: none;">640</TD><TD align="right" class="xl75" style="border-top: none; border-left: none;">-1%</TD><TD align="right" class="xl74" style="border-top: none; border-left: none;">-74,394</TD><TD align="right" class="xl74" style="border-top: none; border-left: none;">-122,394</TD></TR></TBODY></TABLE><P></P><P></P><P>I want ot create a calculated dimesion with the rest of budget for the year: Aggr(IF(min(Month_name)&gt;=(vCurMonth),Sum(Sal*Bench_Data),Sum({&lt;Y={'2015'}&gt;}Fact_bench))-Sum(Budget),BG_bench)</P><P></P><P>But it doesnt work properly.</P><P></P><P>Any ideas?</P></BODY></HTML> Tue, 07 Apr 2015 09:45:26 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-in-Pivot-table/m-p/865600#M302831 2015-04-07T09:45:26Z Re: Calculated Expression in Pivot table https://community.qlik.com/t5/QlikView/Calculated-Expression-in-Pivot-table/m-p/865601#M302832 <HTML><HEAD></HEAD><BODY><P>Guys, any ideas?</P></BODY></HTML> Tue, 07 Apr 2015 12:41:09 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-in-Pivot-table/m-p/865601#M302832 2015-04-07T12:41:09Z Re: Calculated Expression in Pivot table https://community.qlik.com/t5/QlikView/Calculated-Expression-in-Pivot-table/m-p/865602#M302833 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>Can you attach example?</P></BODY></HTML> Tue, 07 Apr 2015 12:44:36 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-in-Pivot-table/m-p/865602#M302833 pokassov 2015-04-07T12:44:36Z Re: Calculated Expression in Pivot table https://community.qlik.com/t5/QlikView/Calculated-Expression-in-Pivot-table/m-p/865603#M302834 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>Nope, it doesnt give me the desired result <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Tue, 07 Apr 2015 13:05:09 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-in-Pivot-table/m-p/865603#M302834 2015-04-07T13:05:09Z