topic Re: exclude list box selection in QlikView

exclude list box selection

sat_tok52 — Thu, 18 Feb 2016 03:24:06 GMT

Hi Guru's,

I have list box have A,B,C data and also have a straight table ,as per my requirement if I select list box data A my straight should exclude A data and it should show B,C Data,it means it should exclude current selection show remaining data.

In any help.

Thanks,

Sateesh.T

Re: exclude list box selection

sunny_talwar — Thu, 18 Feb 2016 03:25:28 GMT

Try this as your set analysis in your expression: {<ListBoxField = e(ListBoxField)>}

For an expression Sum(Sales) you can do -> Sum({<ListBoxField = e(ListBoxField)>}Sales)

Re: exclude list box selection

sat_tok52 — Thu, 18 Feb 2016 03:51:39 GMT

Hi Sunny

Thanks for quick response.When I am using set analysis initially my table not showing any data after selecting data it's working fine but my table should show all data without selecting.

Thanks ,

Sateesh

Re: exclude list box selection

sasikanth — Thu, 18 Feb 2016 03:59:44 GMT

Hi,

Try this

=sum({<ListBoxField ={'*'}-{'$(=GetFieldSelections(ListBoxField ))'}>} Sales)

Re: exclude list box selection

jagan — Thu, 18 Feb 2016 04:21:08 GMT

Hi,

Try like this

=If(GetSelectedCount(ListBoxField) > 0,

Sum({<ListBoxField = e(ListBoxField)>}Sales),

sum(Sales))

Hope this helps you.

Regards,

Jagan.