Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hi,
Could you Please attach your qvw file?
or explain what do you want to do when entering the vCount value
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.
Hi,
Sorry i can't undersatnd
what do you want to do after selecting value from the inputbox?
What the trigger should do?
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.
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.
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.
Toni,
If possible can you see this Thread