topic Ignore selections in listbox in QlikView

Ignore selections in listbox

Anonymous — Fri, 14 Sep 2018 02:01:49 GMT

HI qlik community. I have the next situation:

I have 2 listboxes and 1 pie chart, in the chart i am doing a sum based on the selection of both listboxes.

I want to ignore listbox 2 when agf or cdb is selected, but the problem is that user can select 1 or 2 or 3 thogether and I dont know how to handle the sum for that cases. (Also have in mind if user pick cdb and ap or agf and ap it must sum ignoring selection of listbox 2 for agf and cdb but have the selection for agf)

THanks in advance.

listbox1	listbox 2
AGF	ND
AP	D
CDB

Re: Ignore selections in listbox

jaibau1993 — Fri, 14 Sep 2018 12:58:08 GMT

Could you please provide a sample of data?

It is hard to figure out your problem and reproduce it.

Jaime.

Re: Ignore selections in listbox

jaibau1993 — Fri, 14 Sep 2018 13:34:41 GMT

Hi. I've been thinking and I have find out a possible solution. It works for me supposing that I have understood you:

1) If AGF or CDB selected in LB1, sum for all values in LB2

2) If AGF and CDB not selected, sum for all possible values in LB2

3) If AGF or CDB and something else selected in LB1, sum for all values in LB2 when dimension of LB1 is AGF or CDB and sum for all possible values in LB2 instead

then, supposing that Dim1 is the dimension displayed in LB1 and Dim2 in LB2, you should use

Sum( {<Dim1 =, Dim2=, Dim1 -= $::Dim1 - {'AGF', 'CDB'} > + <Dim1-={'AGF', 'CDB'}> } ValueToBeSumed)

check my attached file where I have tried to reproduce your issue (not quite self explanatory, sorry).

Bests,

Jaime.