topic Re: How To Display Selected Items and Failed Items in a List Box in QlikView

How To Display Selected Items and Failed Items in a List Box

tamilarasu — Thu, 20 Nov 2014 09:34:19 GMT

Hi All,

I want to select bulk records in a list box, so I just kept a input box and stored the all values in a variable. But I wish to do the following things.

* Display selected items and failed items count in a text box.

* Display successfully uploaded items and failed items in a list box.

Note: I have tried and got selected items count but not failed items count.

Can any one help me to solve this.

Many Thanks,

Tamil

Re: How To Display Selected Items and Failed Items in a List Box

morganaaron — Thu, 20 Nov 2014 09:56:21 GMT

Have a look at the attached and see if this is what you want - the "listbox" for the excluded values is a tablebox instead just with presentation altered to appear like a listbox.

Re: How To Display Selected Items and Failed Items in a List Box

tamilarasu — Thu, 20 Nov 2014 10:10:35 GMT

Hi Aaron,

Thank you for your help. But I need to do one more thing. If I enter values that are not listed in list box, I wish to display them as well. Say for example. 12, -, Aaron (Which not in source data) etc.

Re: How To Display Selected Items and Failed Items in a List Box

morganaaron — Thu, 20 Nov 2014 11:01:22 GMT

=(SubStringCount(vMassUpload,chr(10))+1) - GetSelectedCount(S.No)

would give you the count of any items entered in vMassUpload that aren't found in S.No. Listing them is a little trickier, as if you use a PurgeChar() statement you'll lose a "12" if there's a "1" or "2" in the box. Also be wary, if a "-" is entered into that variable box it will act as a deselect on the number that follows but then select all other options.

Bit of a minefield...don't really have a good answer, if you were to do it in the script it would be easier as you could loop statements, but you can't do that from an inputbox either so...sorry!