topic Re: List Box selection creates a group in QlikView

List Box selection creates a group

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

Company asked me to build one of their old models into QlikView. They have a Doughnut Pie chart that shows the Sum(CreditAmount)

per Group. There are 3 groups (Group1, Group2, Other). The trick is that you can select from 2 dropdown boxes which Banks you want to allocate to Group1 and Group2. Whatever was not selected in Group1 (list box 1) and Group2 (list box 2) will automatically fall under "Other". If you selected a Bank in list box 1 (Group1) it will not be available for selection in the list box 2 (Group2)

Any ideas?

Thank you

Re: List Box selection creates a group

MK9885 — Fri, 06 Jul 2018 15:37:16 GMT

What are the values inside those Groups?

use not match or if condition to only bring in required values for the groups?

Re: List Box selection creates a group

nishanthi_8 — Mon, 09 Jul 2018 05:56:37 GMT

Can you post some sample data ?