topic Set Expression in QlikView

topic Set Expression in QlikView https://community.qlik.com/t5/QlikView/Set-Expression/m-p/592851#M219817 <HTML><HEAD></HEAD><BODY><P>I have created a document and attached the same herewith. In this document I have two pivot table names 'Correct one'  and 'New One'</P><P>In this New One pivot table I want the data to appear like as given below</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 897px;"><TBODY><TR><TD class="xl65" height="17" width="42">YEAR</TD><TD class="xl66" style="border-left: none;" width="63"> JAN_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> FEB_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> MAR_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> APR_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> MAY_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> JUN_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> JUL_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> AUG_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> SEP_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> OCT_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> NOV_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> DEC_NRP </TD></TR><TR><TD align="right" height="17">2013</TD><TD class="xl68" style="border-top: none;"> 4,122,270 </TD><TD class="xl68" style="border-top: none; border-left: none;">    5,225,041 </TD><TD class="xl68" style="border-top: none; border-left: none;">    5,436,199 </TD><TD class="xl68" style="border-top: none; border-left: none;">    3,911,853 </TD><TD class="xl68" style="border-top: none; border-left: none;">    5,017,381 </TD><TD class="xl68" style="border-top: none; border-left: none;">    3,978,719 </TD><TD class="xl68" style="border-top: none; border-left: none;">    4,813,178 </TD><TD class="xl68" style="border-top: none; border-left: none;">    4,772,933 </TD><TD class="xl68" style="border-top: none; border-left: none;">    5,844,202 </TD><TD class="xl68" style="border-top: none; border-left: none;">    4,616,779 </TD><TD class="xl68" style="border-top: none; border-left: none;">    4,843,327 </TD><TD class="xl68" style="border-top: none; border-left: none;">    3,715,368 </TD></TR></TBODY></TABLE><P></P><P>The above figures are the data shown in Pivot Table (correct one)  against the respective month No rwos</P><P></P><P>Pls help me to solve this problem</P></BODY></HTML> Fri, 18 Apr 2014 04:08:37 GMT upaliwije 2014-04-18T04:08:37Z Set Expression https://community.qlik.com/t5/QlikView/Set-Expression/m-p/592851#M219817 <HTML><HEAD></HEAD><BODY><P>I have created a document and attached the same herewith. In this document I have two pivot table names 'Correct one'  and 'New One'</P><P>In this New One pivot table I want the data to appear like as given below</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 897px;"><TBODY><TR><TD class="xl65" height="17" width="42">YEAR</TD><TD class="xl66" style="border-left: none;" width="63"> JAN_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> FEB_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> MAR_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> APR_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> MAY_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> JUN_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> JUL_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> AUG_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> SEP_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> OCT_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> NOV_NRP </TD><TD class="xl66" style="border-left: none;" width="72"> DEC_NRP </TD></TR><TR><TD align="right" height="17">2013</TD><TD class="xl68" style="border-top: none;"> 4,122,270 </TD><TD class="xl68" style="border-top: none; border-left: none;">    5,225,041 </TD><TD class="xl68" style="border-top: none; border-left: none;">    5,436,199 </TD><TD class="xl68" style="border-top: none; border-left: none;">    3,911,853 </TD><TD class="xl68" style="border-top: none; border-left: none;">    5,017,381 </TD><TD class="xl68" style="border-top: none; border-left: none;">    3,978,719 </TD><TD class="xl68" style="border-top: none; border-left: none;">    4,813,178 </TD><TD class="xl68" style="border-top: none; border-left: none;">    4,772,933 </TD><TD class="xl68" style="border-top: none; border-left: none;">    5,844,202 </TD><TD class="xl68" style="border-top: none; border-left: none;">    4,616,779 </TD><TD class="xl68" style="border-top: none; border-left: none;">    4,843,327 </TD><TD class="xl68" style="border-top: none; border-left: none;">    3,715,368 </TD></TR></TBODY></TABLE><P></P><P>The above figures are the data shown in Pivot Table (correct one)  against the respective month No rwos</P><P></P><P>Pls help me to solve this problem</P></BODY></HTML> Fri, 18 Apr 2014 04:08:37 GMT https://community.qlik.com/t5/QlikView/Set-Expression/m-p/592851#M219817 upaliwije 2014-04-18T04:08:37Z Re: Set Expression https://community.qlik.com/t5/QlikView/Set-Expression/m-p/592852#M219818 <HTML><HEAD></HEAD><BODY><P>Please clear your requirement with more sample data it is not clear.</P></BODY></HTML> Fri, 18 Apr 2014 04:15:53 GMT https://community.qlik.com/t5/QlikView/Set-Expression/m-p/592852#M219818 its_anandrjs 2014-04-18T04:15:53Z Re: Re: Set Expression https://community.qlik.com/t5/QlikView/Set-Expression/m-p/592853#M219819 <HTML><HEAD></HEAD><BODY><P>Hi Anand</P><P></P><P>Thanks</P><P></P><P>My requirement is to overwrite the existing data in the New one pivot table with highlighted data in the attached table</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 932px;"><TBODY><TR><TD class="xl71" colspan="3" height="18" width="142">Correct One</TD></TR><TR><TD class="xl65" height="17">YEAR</TD><TD class="xl66" style="border-left: none;">MONTH</TD><TD class="xl68">JAN_NRP</TD><TD class="xl68" style="border-left: none;">FEB_NRP</TD><TD class="xl68" style="border-left: none;">MAR_NRP</TD><TD class="xl68" style="border-left: none;">APR_NRP</TD><TD class="xl68" style="border-left: none;">MAY_NRP</TD><TD class="xl68" style="border-left: none;">JUN_NRP</TD><TD class="xl68" style="border-left: none;">JUL_NRP</TD><TD class="xl68" style="border-left: none;">AUG_NRP</TD><TD class="xl68" style="border-left: none;">SEP_NRP</TD><TD class="xl68" style="border-left: none;">OCT_NRP</TD><TD class="xl68" style="border-left: none;">NOV_NRP</TD><TD class="xl68" style="border-left: none;">DEC_NRP</TD></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none;">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1</TD><TD class="xl70" style="border-top: none; border-left: none;">  <SPAN style="color: #ff00ff;">4,122,270</SPAN></TD><TD class="xl68" style="border-top: none; border-left: none;">    5,139,520</TD><TD class="xl68" style="border-top: none; border-left: none;">    6,129,330</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,060,620</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,332,799</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,778,475</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,820,451</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,327,208</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,492,297</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,708,382</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,472,065</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,573,470</TD></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none;">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,122,270</TD><TD class="xl70" style="border-top: none; border-left: none;"> <SPAN style="color: #ff00ff;"> 5,225,041</SPAN></TD><TD class="xl68" style="border-top: none; border-left: none;">    <SPAN style="color: #000000;">6,129,330</SPAN></TD><TD class="xl68" style="border-top: none; border-left: none;">    4,060,620</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,332,799</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,778,475</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,820,451</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,327,208</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,492,297</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,708,382</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,472,065</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,573,470</TD></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none;">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">3</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,122,270</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,225,041</TD><TD class="xl70" style="border-top: none; border-left: none;"> <SPAN style="color: #ff00ff;"> 5,436,199</SPAN></TD><TD class="xl68" style="border-top: none; border-left: none;">    4,060,620</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,332,799</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,778,475</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,820,451</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,327,208</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,492,297</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,708,382</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,472,065</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,573,470</TD></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none;">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">4</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,122,270</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,225,041</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,436,199</TD><TD class="xl70" style="border-top: none; border-left: none;">  3,911,853</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,332,799</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,778,475</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,820,451</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,327,208</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,492,297</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,708,382</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,472,065</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,573,470</TD></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none;">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">5</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,122,270</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,225,041</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,436,199</TD><TD class="xl68" style="border-top: none; border-left: none;">    3,911,853</TD><TD class="xl70" style="border-top: none; border-left: none;"> <SPAN style="color: #ff00ff;"> 5,017,381</SPAN></TD><TD class="xl68" style="border-top: none; border-left: none;">    4,778,475</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,820,451</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,327,208</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,492,297</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,708,382</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,472,065</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,573,470</TD></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none;">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">6</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,122,270</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,225,041</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,436,199</TD><TD class="xl68" style="border-top: none; border-left: none;">    3,911,853</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,017,381</TD><TD class="xl70" style="border-top: none; border-left: none;">  <SPAN style="color: #ff00ff;">3,978,719</SPAN></TD><TD class="xl68" style="border-top: none; border-left: none;">    5,820,451</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,327,208</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,492,297</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,708,382</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,472,065</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,573,470</TD></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none;">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">7</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,122,270</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,225,041</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,436,199</TD><TD class="xl68" style="border-top: none; border-left: none;">    3,911,853</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,017,381</TD><TD class="xl68" style="border-top: none; border-left: none;">    3,978,719</TD><TD class="xl70" style="border-top: none; border-left: none;">  <SPAN style="color: #ff00ff;">4,813,178</SPAN></TD><TD class="xl68" style="border-top: none; border-left: none;">    4,327,208</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,492,297</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,708,382</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,472,065</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,573,470</TD></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none;">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">8</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,122,270</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,225,041</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,436,199</TD><TD class="xl68" style="border-top: none; border-left: none;">    3,911,853</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,017,381</TD><TD class="xl68" style="border-top: none; border-left: none;">    3,978,719</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,813,178</TD><TD class="xl70" style="border-top: none; border-left: none;"> <SPAN style="color: #ff00ff;"> 4,772,933</SPAN></TD><TD class="xl68" style="border-top: none; border-left: none;">    4,492,297</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,708,382</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,472,065</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,573,470</TD></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none;">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">9</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,122,270</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,225,041</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,436,199</TD><TD class="xl68" style="border-top: none; border-left: none;">    3,911,853</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,017,381</TD><TD class="xl68" style="border-top: none; border-left: none;">    3,978,719</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,813,178</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,772,933</TD><TD class="xl70" style="border-top: none; border-left: none;"> <SPAN style="color: #ff00ff;"> 5,844,202</SPAN></TD><TD class="xl68" style="border-top: none; border-left: none;">    5,708,382</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,472,065</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,573,470</TD></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none;">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">10</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,122,270</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,225,041</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,436,199</TD><TD class="xl68" style="border-top: none; border-left: none;">    3,911,853</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,017,381</TD><TD class="xl68" style="border-top: none; border-left: none;">    3,978,719</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,813,178</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,772,933</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,844,202</TD><TD class="xl70" style="border-top: none; border-left: none;">  <SPAN style="color: #ff00ff;">4,616,779</SPAN></TD><TD class="xl68" style="border-top: none; border-left: none;">    5,472,065</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,573,470</TD></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none;">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">11</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,122,270</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,225,041</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,436,199</TD><TD class="xl68" style="border-top: none; border-left: none;">    3,911,853</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,017,381</TD><TD class="xl68" style="border-top: none; border-left: none;">    3,978,719</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,813,178</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,772,933</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,844,202</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,616,779</TD><TD class="xl70" style="border-top: none; border-left: none;"> <SPAN style="color: #ff00ff;"> 4,843,327</SPAN></TD><TD class="xl68" style="border-top: none; border-left: none;">    5,573,470</TD></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none;">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">12</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,122,270</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,225,041</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,436,199</TD><TD class="xl68" style="border-top: none; border-left: none;">    3,911,853</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,017,381</TD><TD class="xl68" style="border-top: none; border-left: none;">    3,978,719</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,813,178</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,772,933</TD><TD class="xl68" style="border-top: none; border-left: none;">    5,844,202</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,616,779</TD><TD class="xl68" style="border-top: none; border-left: none;">    4,843,327</TD><TD class="xl70" style="border-top: none; border-left: none;"> <SPAN style="color: #ff00ff;"> 3,715,368</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 18 Apr 2014 04:29:50 GMT https://community.qlik.com/t5/QlikView/Set-Expression/m-p/592853#M219819 upaliwije 2014-04-18T04:29:50Z