Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
tamilarasu
Champion
Champion

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

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

Labels (1)
3 Replies
morganaaron
Specialist
Specialist

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.

tamilarasu
Champion
Champion
Author

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.

morganaaron
Specialist
Specialist

=(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!