Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
In Listbox properties > General > uncheck Hide Excluded.
Its already unchecked
I think its because the agrr expression, but its needed to make the right count.
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