Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
edp
Contributor

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
Partner
Partner

Re: A strange selection

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

Re: A strange selection

Attached (qvw and image)

image.png

 

View solution in original post

8 Replies
Partner
Partner

Re: A strange selection

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

Highlighted
edp
Contributor

Re: A strange selection

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
Contributor III

Re: A strange selection

Like this?

edp
Contributor

Re: A strange selection

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.

Re: A strange selection

May be something like this

Avg({<Folder, PhotoID = p(PhotoID)>}1)
edp
Contributor

Re: A strange selection

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.

Re: A strange selection

Attached (qvw and image)

image.png

 

View solution in original post

edp
Contributor

Re: A strange selection

ingenious solution, compliments!

Thanks to you and to all those who helped me.

N.