topic Re: GetSelectedCount with counditions in QlikView

GetSelectedCount with counditions

Yuhka — Sat, 16 Nov 2024 20:36:30 GMT

Hello everyone, I'm new to qlikview.

I have a listbox, a button and a chart.

Users select 3-5 items from the listbox and the button changes to blue, click the button and they can see the result of selected items on the chart.

I need to include Category like "#TypeX" in the listbox, but I wouldn't like to count as the selected items.

Is there any way to count the items excluding categories?

Thank you for your support.

sunny_talwar — Mon, 24 Jun 2019 11:42:17 GMT

May be change your condition to this

=GetSelectedCount(Selections) > 0 and Count({<Selections -= {"#Type*"}>}Selections) >= 3 and Count({<Selections -= {"#Type*"}>}Selections) <= 5

Yuhka — Fri, 28 Jun 2019 04:59:24 GMT

Thank you for your reply.

It worked perfectly! Thank you very much!

sunny_talwar — Mon, 01 Jul 2019 16:10:41 GMT

Glad it did... happy to help