topic List Box's Gray values disappear in QlikView

List Box's Gray values disappear

rafael5958 — Sat, 16 Nov 2024 02:01:45 GMT

Hi,

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

=if(aggr(count({$<TIPO_TITULARIDADE={'2-Titularidade diferente'},CN-={'IO','EST'},CADASTROOD_NOME-={'NÃO INFORMADO','NA','',NULL}>} distinct ID_TITULAR),ID_OD)>0,NOME_P&' - '& ID_OD)

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?

Thanks

Re: List Box's Gray values disappear

Arthur_Fong — Wed, 06 Nov 2019 00:30:05 GMT

In Listbox properties > General > uncheck Hide Excluded.

Re: List Box's Gray values disappear

rafael5958 — Wed, 06 Nov 2019 12:06:27 GMT

Its already unchecked

Re: List Box's Gray values disappear

rafael5958 — Wed, 06 Nov 2019 14:20:55 GMT

I think its because the agrr expression, but its needed to make the right count.

Re: List Box's Gray values disappear

Brett_Bleess — Mon, 11 Nov 2019 17:56:28 GMT

Have a look at the following Design Blog post, it might be helpful:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Regards,
Brett