Exclude values depending on windows checkboxes Part 2

[Sahal]

Hi,

This is a follow up question for:

(Exclude values depending on windows checkboxes)

https://community.qlik.com/message/967769?et=watches.email.thread#967769

I did not want to "uncheck" or ask a new question in the other discussion (is that even possible?) so here is my follow up question.

I have used E() function for exclude values in a chart but how do i keep ALL values visible until i choose what i want to exlude?.

In my chart i have this expression:

On the right i have a listbox with the same field (Name) and on the left i now have a empty chart because i have not choosen any one to exclude. However i would like to have them all visible until i check them i the right listbox.

=count( {$<Name= e(Name) >} Name )

[sunny_talwar · Accepted solution]

May be this:

If(GetSelectedCount(Name) = 0, Count(Name), Count({<Name = e(Name)>} Name))