Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Select ALL in Listbox

Hi All,

I do not have expertise in Qlikview so bear with me with these silly questions. What does the select all mean in the list box. I know it turns the whole list box green but it also changes the values of other list boxes. In the two list boxes I have included the count of the total values in list box along with their category. See the Attached two pics, once I click select ALL on the Parent 309 List Box the Sub 480 turns into Sub 336. What it apparently implies is the Parent 309 has relationship with 336 out of 480 Sub. So is there anyone I can see the rest of the sub which is 144 (480-336)?

Thanks in Advance.

11 Replies
Not applicable
Author

Thank you everyone for your time and hard work. I was able to get the unmatching Sub to get filtered out.

=(Aggr(Only({<d1sub.clientid = p({<d2.month ={12}, Parent= >}) -  p({<d2.month = {11}, Parent= >}), Parent= >} d1sub.clientid), d1sub.clientid))

Capture.PNG

swuehl
MVP
MVP

You're welcome.

For these kind of issues, it's always extremely helpful if you provide as much context as possible, e.g. when using calculated dimensions in your list box, state the expression you are using (and maybe describe your data model also).

It's often best and easiest to create a small sample QVW and attach it to your question.