topic Re: List Box's Gray values disappear in QlikView

List Box's Gray values disappear

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am using an expression to create a List Box object. The expression is :

If( aggr( sum(SalesAmount), CalendarYear) > 0, CalendarYear).

It shows 5 values - 2010, 2011, 2012, 2013, 2014

The problem is whenever I select any value from this object, only selected value remains in the list Box while the rest of the values disappear from the List Box object.

How can I show all the excluded values too in Listbox?

Please find the attached screenshot.

Thanks

Re: List Box's Gray values disappear

sunny_talwar — Tue, 07 Feb 2017 12:56:18 GMT

May be try this:

Aggr(If(Sum({<CalendarYear>}SalesAmount) > 0, CalendarYear), CalendarYear)

Re: List Box's Gray values disappear

Tue, 07 Feb 2017 13:00:01 GMT

Sorry its not working

Re: List Box's Gray values disappear

sunny_talwar — Tue, 07 Feb 2017 13:04:33 GMT

This should work

=Aggr(If(Sum({<CalendarYear>}SalesAmount) > 0, Only({<CalendarYear>}CalendarYear)), CalendarYear)

Update: Sample attached

Re: List Box's Gray values disappear

Anonymous — Tue, 07 Feb 2017 13:10:28 GMT

Is the Hide Excluded from Properties - General Unchecked?

Re: List Box's Gray values disappear

Tue, 07 Feb 2017 13:19:57 GMT

Awesome!

Re: List Box's Gray values disappear

Anonymous — Tue, 07 Feb 2017 13:22:05 GMT

Hi Abhishek,

Please check if you have unchecked the Hide excluded in listbox properties.