https://community.qlik.com/t5/QlikView/Getting-Selected-Value-of-Locked-Field-into-a-Variable/m-p/1770618#M454591 <P>If i understand correct, there is an intention that you want to unlock from QV when it involved N-Printing or is this something different? There might be some filter assigned to the button where you hit to enter the dashboard.&nbsp;</P> Sun, 27 Dec 2020 14:04:09 GMT Anil_Babu_Samineni 2020-12-27T14:04:09Z https://community.qlik.com/t5/QlikView/Getting-Selected-Value-of-Locked-Field-into-a-Variable/m-p/1769882#M454531 <P>Hi, Im having difficulty getting the selected value of a list box (which is locked) into a variable.</P><P>&nbsp;</P><P>When a user clicks to 'Enter Dashboard' from the front page of our qvw - an Organisation field is locked based on the UserID.&nbsp; I also need to pass this listbox value to a variable to be used in NPrinting.&nbsp;&nbsp;<BR /><BR />This is the expression Im using in the variable :</P><P class="p1">=<SPAN class="s1">If</SPAN>(<SPAN class="s1">count</SPAN>(<SPAN class="s1">distinct</SPAN> <SPAN class="s2">[Organisation]</SPAN>)=1,<SPAN class="s2">[Organisation]</SPAN>,<BR /><SPAN class="s1">&nbsp; If</SPAN>(<SPAN class="s1">count</SPAN>(<SPAN class="s1">distinct</SPAN> <SPAN class="s2">[Organisation]</SPAN>)&gt;1,'Multiple Selected','No Organisation Chosen')<SPAN class="Apple-converted-space">&nbsp;</SPAN></P><P><BR />When I run a report after clicking to enter the app (ie the Organisation field is locked to one Organisation) the Nprint Report is showing 'Multiple Selected'. If I unlock this field and select an Organisation the correct value is displayed in the report.&nbsp;&nbsp;<BR /><BR /></P><P>Is there a specific method to get the selected value from a locked field?</P><P>&nbsp;</P><P>Many thanks</P> Mon, 21 Dec 2020 19:50:50 GMT https://community.qlik.com/t5/QlikView/Getting-Selected-Value-of-Locked-Field-into-a-Variable/m-p/1769882#M454531 prees959 2020-12-21T19:50:50Z https://community.qlik.com/t5/QlikView/Getting-Selected-Value-of-Locked-Field-into-a-Variable/m-p/1770618#M454591 <P>If i understand correct, there is an intention that you want to unlock from QV when it involved N-Printing or is this something different? There might be some filter assigned to the button where you hit to enter the dashboard.&nbsp;</P> Sun, 27 Dec 2020 14:04:09 GMT https://community.qlik.com/t5/QlikView/Getting-Selected-Value-of-Locked-Field-into-a-Variable/m-p/1770618#M454591 Anil_Babu_Samineni 2020-12-27T14:04:09Z