topic Re: OnInput trigger issue with variable in QlikView

OnInput trigger issue with variable

jagannalla — Wed, 27 Jul 2011 06:39:53 GMT

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.

OnInput trigger issue with variable

Wed, 27 Jul 2011 07:41:51 GMT

Hi,

Could you Please attach your qvw file?

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

Re: OnInput trigger issue with variable

jagannalla — Wed, 27 Jul 2011 08:37:57 GMT

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.

OnInput trigger issue with variable

Wed, 27 Jul 2011 08:51:18 GMT

Hi,

Sorry i can't undersatnd

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

What the trigger should do?

Re: OnInput trigger issue with variable

ToniKautto — Wed, 27 Jul 2011 08:52:21 GMT

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.

Re: OnInput trigger issue with variable

jagannalla — Wed, 27 Jul 2011 11:47:12 GMT

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.

Re: OnInput trigger issue with variable

ToniKautto — Wed, 27 Jul 2011 13:08:35 GMT

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.

Re: OnInput trigger issue with variable

jagannalla — Wed, 27 Jul 2011 13:17:42 GMT

Toni,

If possible can you see this Thread