Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

A strange selection

Hello guys,

a have a pivot table with these data inside:

PhotoID    Folder

1                   A

1                  B

2                  A

3                  B

 

Selecting the "B" folder, I'd like to see not only the pairs 1/B and 3/B but also the pair 1/A, thus all the occurrences of the photo/folders where a particular folder is at least one of the folder in which a photo is stored.

Hope it's clear, if not pls. tell me and I'll retry to explain much better.

Thanks.

N.

2 Solutions

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

Thats the default behaviour. to override it you would need to use set analysis in your expression.
something like
Folder=,PhotoID=p(PhotoID)
breaking it down
Folder= ignore folder selection s
PhotoID=p(PhotoID) - all photo ids possible should be displayed

View solution in original post

sunny_talwar

Attached (qvw and image)

image.png

 

View solution in original post

8 Replies
dplr-rn
Partner - Master III
Partner - Master III

Thats the default behaviour. to override it you would need to use set analysis in your expression.
something like
Folder=,PhotoID=p(PhotoID)
breaking it down
Folder= ignore folder selection s
PhotoID=p(PhotoID) - all photo ids possible should be displayed
Anonymous
Not applicable
Author

Pls. forgive me, but I haven't understand your suggestion: can you explain better how have I to use the set_analysis?

Thks.

N.

gf
Creator III
Creator III

Like this?

Anonymous
Not applicable
Author

ok, what about managing these data with a pivot table?

I've added it to your sheet, but when I select the "A" folder, it returns only the "A" rows and not the pair 1/B

Thks.

N.

sunny_talwar

May be something like this

Avg({<Folder, PhotoID = p(PhotoID)>}1)
Anonymous
Not applicable
Author

Thank you for the reply.

Unfortunately, I'm not so skilled to catch you suggestion; would you mind to apply it to the qvw files I've attached previously?

Thks.

N.

sunny_talwar

Attached (qvw and image)

image.png

 

Anonymous
Not applicable
Author

ingenious solution, compliments!

Thanks to you and to all those who helped me.

N.