Exclude values depending on windows checkboxes Part 2

Sahal — Fri, 05 Feb 2016 15:19:55 GMT

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 )

Re: Exclude values depending on windows checkboxes Part 2

sunny_talwar — Fri, 05 Feb 2016 22:04:42 GMT

May be this:

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

topic Exclude values depending on windows checkboxes Part 2 in QlikView

Exclude values depending on windows checkboxes Part 2

Re: Exclude values depending on windows checkboxes Part 2