Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Yuhka
Contributor III
Contributor III

GetSelectedCount with counditions

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? 

キャプチャ.PNG

 

 

 

 

 

 

 

 

 

Thank you for your support.

Labels (6)
1 Solution

Accepted Solutions
sunny_talwar

May be change your condition to this

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

View solution in original post

3 Replies
sunny_talwar

May be change your condition to this

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

@sunny_talwar 

Thank you for your reply.

It worked perfectly! Thank you very much!

sunny_talwar

Glad it did... happy to help