topic Re: Problem with GetSelectedCount in QlikView

Problem with GetSelectedCount

k_burata — Tue, 09 Feb 2016 08:12:57 GMT

Hi all,

I added a Field Event Trigger to count the items selected in a list box and then based on this toggle the flag variable.

It should make the value = 0 whenever I select more than 1 item on the list box as well as when I make no selection.

Works fine when I select one or more item on the list box but when I cancel the selection by clicking on the item my IF statement won't work.

Here's my IF statement:

=if(GetSelectedCount([Currency Code]) <> 1, 0, vToggle )

Thanks.

Mark_Little — Tue, 09 Feb 2016 09:49:52 GMT

HI Kim,

Have you added the same expression in the on change Action?

Mark

sunny_talwar — Tue, 09 Feb 2016 09:53:23 GMT

Would you be able to share a sample where it isn't working?

antoniotiman — Tue, 09 Feb 2016 10:29:59 GMT

Hi Kim,

You use Count(DISTINCT [Currency Code]) instead of GetSelectedCount

Regards,

Antonio

k_burata — Wed, 10 Feb 2016 00:46:32 GMT

This solved it!

Thanks Mark