topic Re: Set Text Value When Listbox Has Nothing Selected in QlikView

Set Text Value When Listbox Has Nothing Selected

Thu, 03 Jul 2014 10:50:20 GMT

Hi all,

I'm trying to build up a title dynamically and have the following code to generate the values from my 'Attempt' list box.
This is working, however when nothing is selected at all, I'd like the text to default to 'ALL'.

Is there any way to do this?

Current code I'm using in the textbox expression is below.
Thanks

GetFieldSelections(Attempt)

Re: Set Text Value When Listbox Has Nothing Selected

sasikanth — Thu, 03 Jul 2014 10:55:03 GMT

try like below

if(getSelectedCount(attempt)>0,getFieldSelections(attempt),'ALL')

Re: Set Text Value When Listbox Has Nothing Selected

tresB — Thu, 03 Jul 2014 10:57:28 GMT

Like:

If(GetSelectedCount(Attempt)=0, 'All', GetCurrentSelection(Attempt))

Re: Set Text Value When Listbox Has Nothing Selected

Thu, 03 Jul 2014 11:48:26 GMT

Thanks but now it just seems to stay as 'ALL'. When I do make a selection the values don't show. It just stays as 'ALL'

Any ideas?

Re: Set Text Value When Listbox Has Nothing Selected

Thu, 03 Jul 2014 11:55:03 GMT

This worked. Thanks very much!

Re: Set Text Value When Listbox Has Nothing Selected

sasikanth — Thu, 03 Jul 2014 11:55:23 GMT

if you select any thing in Attempt then that will be shown else 'ALL' will be shown ,

what you are getting and what you want exactly