Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 )
May be this:
If(GetSelectedCount(Name) = 0, Count(Name), Count({<Name = e(Name)>} Name))
May be this:
If(GetSelectedCount(Name) = 0, Count(Name), Count({<Name = e(Name)>} Name))