Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))
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.