topic Re: merging to expresion in QlikView https://community.qlik.com/t5/QlikView/merging-to-expresion/m-p/423371#M157810 <HTML><HEAD></HEAD><BODY><P> Sum({$&lt;<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">VOUCHER_ID={'LIV'},</SPAN> month = ,year=&gt;}<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">BAL_QTY</SPAN>)</P></BODY></HTML> Fri, 03 May 2013 11:31:09 GMT er_mohit 2013-05-03T11:31:09Z merging to expresion https://community.qlik.com/t5/QlikView/merging-to-expresion/m-p/423369#M157808 <HTML><HEAD></HEAD><BODY><P>AOA</P><P></P><P>I have a table in which i m showing sum of bal_qty for only thos voucher having value LIV</P><P></P><P>sum({&lt;VOUCHER_ID={'LIV'}&gt;}BAL_QTY)</P><P></P><P>Now I also want that selection of year and month dimension doesnot effect on this table.</P><P></P><P>sum({&lt;YEAR,MONTH=&gt;}BAL_QTY)</P><P></P><P>NOW this two exprsion are working fine individualy how to combine them on single expresion to get desired out put</P><P>which is</P><P></P><P>(sum of bal_qty where vouvher_id='LIV' and free from year and month selection)</P><P></P><P></P><P>regards</P></BODY></HTML> Fri, 03 May 2013 08:07:44 GMT https://community.qlik.com/t5/QlikView/merging-to-expresion/m-p/423369#M157808 2013-05-03T08:07:44Z Re: merging to expresion https://community.qlik.com/t5/QlikView/merging-to-expresion/m-p/423370#M157809 <HTML><HEAD></HEAD><BODY><P>Hi, try this...</P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">sum({&lt;VOUCHER_ID={'LIV'}, <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">YEAR= ,MONTH=</SPAN> &gt;}BAL_QTY)</SPAN></P></BODY></HTML> Fri, 03 May 2013 11:28:55 GMT https://community.qlik.com/t5/QlikView/merging-to-expresion/m-p/423370#M157809 christian77 2013-05-03T11:28:55Z Re: merging to expresion https://community.qlik.com/t5/QlikView/merging-to-expresion/m-p/423371#M157810 <HTML><HEAD></HEAD><BODY><P> Sum({$&lt;<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">VOUCHER_ID={'LIV'},</SPAN> month = ,year=&gt;}<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">BAL_QTY</SPAN>)</P></BODY></HTML> Fri, 03 May 2013 11:31:09 GMT https://community.qlik.com/t5/QlikView/merging-to-expresion/m-p/423371#M157810 er_mohit 2013-05-03T11:31:09Z Re: merging to expresion https://community.qlik.com/t5/QlikView/merging-to-expresion/m-p/423372#M157811 <HTML><HEAD></HEAD><BODY><P>You can take these as two seperate expressions.</P></BODY></HTML> Fri, 03 May 2013 11:35:05 GMT https://community.qlik.com/t5/QlikView/merging-to-expresion/m-p/423372#M157811 sujeetsingh 2013-05-03T11:35:05Z