List Box's Gray values disappear

[rafael5958]

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

[Arthur_Fong]

In Listbox properties > General > uncheck Hide Excluded.

[rafael5958]

Its already unchecked

[rafael5958]

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

[Brett_Bleess]

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