topic How to make a variable not depend on current selections in QlikView https://community.qlik.com/t5/QlikView/How-to-make-a-variable-not-depend-on-current-selections/m-p/341771#M126242 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">=sum({1}if([Calendar Date]&gt;vFYStart&nbsp; and [Calendar Date]&lt;vCD and [Division Abbreviation]='ATD',[FACT_SHIPMENTS_AMOUNT_TY]))/vNumDays</SPAN></P></BODY></HTML> Tue, 08 May 2012 15:38:06 GMT 2012-05-08T15:38:06Z How to make a variable not depend on current selections https://community.qlik.com/t5/QlikView/How-to-make-a-variable-not-depend-on-current-selections/m-p/341770#M126241 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>The following is the code for my variable:</P><P></P><P>=sum(if([Calendar Date]&gt;vFYStart&nbsp; and [Calendar Date]&lt;vCD and [Division Abbreviation]='ATD',[FACT_SHIPMENTS_AMOUNT_TY]))/vNumDays</P><P></P><P>vNumDays doesn't change, but the [Calendar Date] changes depending on my selection in the document.&nbsp; How to get this variable to be regardless of selection?</P></BODY></HTML> Tue, 08 May 2012 15:33:09 GMT https://community.qlik.com/t5/QlikView/How-to-make-a-variable-not-depend-on-current-selections/m-p/341770#M126241 2012-05-08T15:33:09Z How to make a variable not depend on current selections https://community.qlik.com/t5/QlikView/How-to-make-a-variable-not-depend-on-current-selections/m-p/341771#M126242 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">=sum({1}if([Calendar Date]&gt;vFYStart&nbsp; and [Calendar Date]&lt;vCD and [Division Abbreviation]='ATD',[FACT_SHIPMENTS_AMOUNT_TY]))/vNumDays</SPAN></P></BODY></HTML> Tue, 08 May 2012 15:38:06 GMT https://community.qlik.com/t5/QlikView/How-to-make-a-variable-not-depend-on-current-selections/m-p/341771#M126242 2012-05-08T15:38:06Z