Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prees959
Creator II
Creator II

Getting Selected Value of Locked Field into a Variable

Hi, Im having difficulty getting the selected value of a list box (which is locked) into a variable.

 

When a user clicks to 'Enter Dashboard' from the front page of our qvw - an Organisation field is locked based on the UserID.  I also need to pass this listbox value to a variable to be used in NPrinting.  

This is the expression Im using in the variable :

=If(count(distinct [Organisation])=1,[Organisation],
  If(count(distinct [Organisation])>1,'Multiple Selected','No Organisation Chosen') 


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.  

Is there a specific method to get the selected value from a locked field?

 

Many thanks

1 Reply
Anil_Babu_Samineni

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. 

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)