topic Display excluded values within a range in QlikView https://community.qlik.com/t5/QlikView/Display-excluded-values-within-a-range/m-p/105737#M753288 <HTML><HEAD></HEAD><BODY><P>Hi There,</P><P></P><P>I'm currently trying to find a way to display excluded values within the range of a selection. What I have is a list of transactions (attached to a program and a financial year). When a user selects a list of FY's (e.g. 2018/2018, 2017/2018, 2015/2016), I'm wanting to display in a text box the years within the range that they haven't selected (for the above case, that would be <SPAN style="font-size: 13.3333px;">2016/2017). </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>I've got this working when a user has not made selections in any other filters, but once they've selected a program, then it doesn't behave the same way:</P><P></P><P><IMG alt="without prog.PNG" class="jive-image image-1" src="/legacyfs/online/215966_without prog.PNG" style="height: auto;" /></P><P><IMG alt="with prog.PNG" class="jive-image image-2" src="/legacyfs/online/215967_with prog.PNG" style="height: auto;" /></P><P></P><P>Is there a way to change the calculation so that the behavior remains consistent regardless of what's selected in other filters?</P><P></P><P>I've attached the file as well.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Display excluded values within a range https://community.qlik.com/t5/QlikView/Display-excluded-values-within-a-range/m-p/105737#M753288 <HTML><HEAD></HEAD><BODY><P>Hi There,</P><P></P><P>I'm currently trying to find a way to display excluded values within the range of a selection. What I have is a list of transactions (attached to a program and a financial year). When a user selects a list of FY's (e.g. 2018/2018, 2017/2018, 2015/2016), I'm wanting to display in a text box the years within the range that they haven't selected (for the above case, that would be <SPAN style="font-size: 13.3333px;">2016/2017). </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>I've got this working when a user has not made selections in any other filters, but once they've selected a program, then it doesn't behave the same way:</P><P></P><P><IMG alt="without prog.PNG" class="jive-image image-1" src="/legacyfs/online/215966_without prog.PNG" style="height: auto;" /></P><P><IMG alt="with prog.PNG" class="jive-image image-2" src="/legacyfs/online/215967_with prog.PNG" style="height: auto;" /></P><P></P><P>Is there a way to change the calculation so that the behavior remains consistent regardless of what's selected in other filters?</P><P></P><P>I've attached the file as well.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Display-excluded-values-within-a-range/m-p/105737#M753288 Anonymous 2020-11-25T16:16:04Z