topic Don't Include Data unless selected in QlikView

Don't Include Data unless selected

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

Hi,

I want my data to exclude a certain field unless the selection for it on the list box is selected. Is this possible? I was trying set analysis but cannot get it.

According to this page, the below set analysis excludes the year 2000 unless it is selected.

Set modifiers with set operators ‒ Qlik Sense

sum( {$<Year = Year + ({“20*”,1997} – {2000}) >} Sales )

My set analysis is as follows. FieldB has two options, Y and N. I want the data to exclude FieldB Y values unless I select it from a listbox.

Sum({$<FieldB = FeldB -({Y}) >}FieldA)

Re: Don't Include Data unless selected

vishsaggi — Mon, 04 Dec 2017 19:23:38 GMT

May be try this?

= Sum({$< FieldB = {"*"} - {'Y'} >} FieldA)

Re: Don't Include Data unless selected

sunny_talwar — Mon, 04 Dec 2017 19:24:50 GMT

May be this

=Sum({<FieldB -= {'Y'}>+<FieldB = {"$(=GetFieldSelections(FieldB))"}>}FieldA)

Re: Don't Include Data unless selected

greend21 — Mon, 04 Dec 2017 19:33:38 GMT

Closer, but this then ONLY shows field B when selected

Re: Don't Include Data unless selected

sunny_talwar — Mon, 04 Dec 2017 19:35:58 GMT

It is showing me N without selection, what is the problem?

Re: Don't Include Data unless selected

trdandamudi — Mon, 04 Dec 2017 19:49:51 GMT

I modified Sunny expression, Is this what you are looking for?

If(GetFieldSelections(FieldB)>1,
Sum(FieldA),
Sum({<FieldB -= {'Y'}>+<FieldB = {"$(=GetFieldSelections(FieldB))"}>}FieldA))