Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
jagannalla
Partner - Specialist III
Partner - Specialist III

OnInput trigger issue with variable

Hi All,

I've a small issue. I had a listbox with expresssion and i'm storing all selections of this listbox in variable.

For Eg:

I taken the code in variable is like this.

vVariable=(if(GetSelectionCount(A)>0,GetFieldSelections(A),',',500),'')

- It's working 5n upto now. But, i've a inputbox with another variable vCount with differen values.

For Eg:

vCount =1,2,,3,4.....

- I written variable event  trigger for this variable OnInput to select all the data of listbox. But the variable  vVariable doesn't hold any values.

1 Solution

Accepted Solutions
jagannalla
Partner - Specialist III
Partner - Specialist III
Author

Toni,

I got solution for this, i tried macro code to achive this solution.

In variable event trigger for variable i taken below macro code

sub SelectAllData

         ActiveDocument.GetSheetObject("LB01").SelectAll

end sub

- Now when i change the value in input box it selected all the data of listbox. And also holding dat selections in another variable.

View solution in original post

7 Replies
Not applicable

Hi,

Could you Please attach your qvw file?

or explain what do you want to do when entering the vCount value

jagannalla
Partner - Specialist III
Partner - Specialist III
Author

Hi,

I attached sample qvw file. After the look of my qvw file just you select the values in input box and see the result in listbox and test object. The test object holds * instead of data.

To see the data u just select the data of listbox manually.

Not applicable

Hi,

Sorry i can't undersatnd

what do you want to do after selecting value from the inputbox?

What the trigger should do?

ToniKautto
Employee
Employee

I agree this looks a bit odd, since you get the actual search string and not the selections. This actually will be the same even if you do the search * manually, hence it is not related to the trigger as far as I can tell.

Please report this issue to QlikView Support for more detailed evaluation;

http://www.qlik.com/us/services/support/phone-email-support

If this has worked before, please clarify to support what has been changed when it stopped working. For example if this has occured after an upgrade from QV9 to QV10 or a SR upgrade.

jagannalla
Partner - Specialist III
Partner - Specialist III
Author

Toni,

I got solution for this, i tried macro code to achive this solution.

In variable event trigger for variable i taken below macro code

sub SelectAllData

         ActiveDocument.GetSheetObject("LB01").SelectAll

end sub

- Now when i change the value in input box it selected all the data of listbox. And also holding dat selections in another variable.

ToniKautto
Employee
Employee

Great that you found the workaround.

I still find the result a bit strange so it is now reported as bug 40687, handling why GetFieldSelections() returns the searchstring and not the actual selections.

jagannalla
Partner - Specialist III
Partner - Specialist III
Author

Toni,

If possible can you see this Thread