topic Re: Default List Box Selection - Exclude a value in QlikView

Default List Box Selection - Exclude a value

mfigueiredo — Tue, 22 Sep 2015 14:50:11 GMT

Hi Qlik Community,

I've been trying to find this answer to this question, but with no sucess so far.

I have a List Box with several values, and a value that should always be excluded. This is the rule unless I need to generate a table/chart/text box with that information.

In short, it HAS to be there, but always excluded/filtered from same listbox.

However, when the user selects something in that listbox and than disselects, all values in that field are included. I don't want to condition all charts with set analysis, I think it would be easier to make a default state in a List Box.

Meaning if nothing is selected in the listbox, exclude that value.

So I want to use an expression in a List Box. Currently I have

=if(GetSelectedCount(GroupCd) > 1,

GroupCd, GroupCd =-'CONSUMPTION')

Clearly, I have my syntax wrong, and can't, for the life of me, get it to work.

Can you help me?

Thank you,

Mariana.

Re: Default List Box Selection - Exclude a value

m_woolf — Tue, 22 Sep 2015 14:57:38 GMT

I don't understand why you don't just permanently exclude that value from the listbox.

The charts are built off the listbox. They are built off the underlying field, which still has all values.

Re: Default List Box Selection - Exclude a value

Anonymous — Tue, 22 Sep 2015 15:02:12 GMT

try

=if(GetSelectedCount(GroupCd) > 1,

GroupCd, if (GroupCd<>'CONSUMPTION',GroupCd))

Re: Default List Box Selection - Exclude a value

mfigueiredo — Tue, 22 Sep 2015 15:05:06 GMT

Hi,

That doesn't work. I did exclude the value from the list box, but if I clear the field, the charts go back to including it.

Maybe another solution?

Thank you.

Re: Default List Box Selection - Exclude a value

m_woolf — Tue, 22 Sep 2015 15:07:55 GMT

If you want the charts to exclude the value, why not create another field in script that down't include that value:

if (GroupCd<>'CONSUMPTION',GroupCd)) as GroupCdForCharts,

Re: Default List Box Selection - Exclude a value

mfigueiredo — Tue, 22 Sep 2015 15:09:15 GMT

Hi Rudolf,

Thanks for your answer.

I tried your expression, however the result is that when I select a value, and then disselect, the list box excludes CONSUMPTION but includes this value in the charts.

Any other ideas?

Thank you,

Mariana

Re: Default List Box Selection - Exclude a value

mfigueiredo — Tue, 22 Sep 2015 15:17:51 GMT

Hi,

I can try that.

Thank you.

Re: Default List Box Selection - Exclude a value

Anonymous — Tue, 22 Sep 2015 15:24:05 GMT

I suppose that you Need to work with set Analysis

or better way: exclude this value while loading your data in script

maybe other way round is better. what for you Need this value?

if so, create another table for selection of this value (might be diffcult due

to syntetic key etc.)

Re: Default List Box Selection - Exclude a value

mfigueiredo — Tue, 22 Sep 2015 15:26:13 GMT

Hi Rudolf,

I agree, it seems easier.

Currently trying to grasp the syntax to exclude it from the script.

Thanks for your help,

Mariana.

Re: Default List Box Selection - Exclude a value

cjohnson — Tue, 22 Sep 2015 19:35:27 GMT

Hi Mariana,

Try the following syntax instead:

=if(GetSelectedCount(GroupCd) > 1,

GroupCd, IF(NOT MATCH(GroupCd, 'CONSUMPTION'), GroupCd))

See below for an example:

Thanks,

Camile