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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

The set analysis within the p() functions will react on user selections, so you may need to disregard Parent selections:

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

Not really sure if you need the third Parent=.

View solution in original post

11 Replies
Not applicable
Author

The second image.

Capture1.PNG

sunny_talwar

Where exactly are you trying to view them? List box or text box? Are you wanting to make selection in them? Please elaborate your requirement a little bit more.

Not applicable
Author

Hi Sunny,

I want to be able to view the 144. I have attached two images one without the select All and one with Select All. When I select ALL on the Parent 309 the Sub 480 changes to Sub 336. I want to know the remaining 144. Is there anyway I can view the 144 and please entail the meaning of Select All on the list box?

Thanks in Advance

HirisH_V7
Master
Master

Hi,

That's due to association of the fields with respect to each other,

For example in Your  List Boxes,


Each Parent ID's may have multiple Sub ID's and these Sub ID's may be same for some other Parent ID's.Such that you will see the change of count in the list boxes.

-->Try this way for two list boxes,

Count(Distinct Parent ID)

Count(Distinct  Sub ID)

You can See the exact number of sub ID's for each Parent ID.

Hope this helps,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
swuehl
MVP
MVP

It seems that some of your Sub have no relation to Parent,

You can see these subs after you selected all in Parent, when you right click on Sub list box and 'Select Excluded'.

Now your 144 Sub should get selected and 0 Parent possible.

sunny_talwar

If getting the count of all Sub (when you select all parent) is the goal then you can create an expression which ignores selection in parent field.

=Count({<Parent>} Sub) // you can add distinct if needed

Select all is select all possible values in Parent field, there seems to be Sub which are not associated to any Sub. For example look at the attached image:

Capture.PNG

In the dummy sample I created, there are certain Sub which doesn't have a parent. If you would do select all in Parent you will only see those Sub which have a non-null parent.

Does that make sense? I am attaching the dummy application I prepared for you to play around with.

HTH

Best,

Sunny

jagan
Partner - Champion III
Partner - Champion III

Hi,

I there is no relation for those missing items with the Parent.  You can identify them like below

Create a table box and use this two fields as dimensions and now you can find them by checking the missing values in Parent field.

Regards,

Jagan.

Not applicable
Author

Thanks for all of your responses guys. Keeping in mind I am not a guru with this tool. This might be redundant but forebear with me. I am attaching three images the first one where the data is simple and straightforward and no selection is made. The second one the parent is select all where the sub gets filtered out with the relationships. The third one I do select all on the already filtered out sub and the parent changes from 309 to 137. I want to see the 144 Sub which have no relation to the parent but the sub since it is in list box expression formula (=Aggr(Only({<d1sub.clientid = p({<d2.month ={12}>}) -  p({<d2.month = {11} >}) >} d1sub.clientid), d1sub.clientid)) does not display this for some reason. Is it the 137 filtered out parent IDs the 144 Sub IDs connected to?

Will appreciate any sort of help here!!!!!

Capture1.PNGCapture.PNGCapture2.PNG

swuehl
MVP
MVP

The set analysis within the p() functions will react on user selections, so you may need to disregard Parent selections:

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

Not really sure if you need the third Parent=.