topic Set Analysis or ??? in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-or/m-p/1218909#M390015 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I want to create an object where the output is based on certain selections. E.G</P><P>In the attached sample data and QVW, </P><UL><LI>The Rmode will be default selected to C</LI><LI>The User will make a selection for L1</LI><LI>The adjoining Line chart has Calendar year on X axis and Calculation on Y Axis</LI><LI>If the user does not make a selection for RYear, then the Calc in the chart should calculate 'calc'&nbsp; based on Calendar year</LI><LI>Calc=((W1*GW1) +(F1*GF1)+(M1*GM1))*CF)</LI></UL><P>I am not sure how to force the system to select Calendar year instead of RYear for calculating 'Calc'. </P><P>Looking for some expert advise.</P></BODY></HTML> Wed, 09 Nov 2016 01:07:13 GMT 2016-11-09T01:07:13Z Set Analysis or ??? https://community.qlik.com/t5/QlikView/Set-Analysis-or/m-p/1218909#M390015 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I want to create an object where the output is based on certain selections. E.G</P><P>In the attached sample data and QVW, </P><UL><LI>The Rmode will be default selected to C</LI><LI>The User will make a selection for L1</LI><LI>The adjoining Line chart has Calendar year on X axis and Calculation on Y Axis</LI><LI>If the user does not make a selection for RYear, then the Calc in the chart should calculate 'calc'&nbsp; based on Calendar year</LI><LI>Calc=((W1*GW1) +(F1*GF1)+(M1*GM1))*CF)</LI></UL><P>I am not sure how to force the system to select Calendar year instead of RYear for calculating 'Calc'. </P><P>Looking for some expert advise.</P></BODY></HTML> Wed, 09 Nov 2016 01:07:13 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-or/m-p/1218909#M390015 2016-11-09T01:07:13Z