Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Transfering the Intersection of Selections Using Alternate States

This video will show how to find the intersection of selections in two listboxes and transfer the intersections to a third listbox using alternate states.

The Expression used in the video is:

='(' & Concat({Group1 * Group2} ProductName, '|') & ')'

http://youtu.be/_7nLV75qnwc

9 Replies
Not applicable

Re: Transfering the Intersection of Selections Using Alternate States

Hi Josh

I have tried your approach and not sure why it doesn't work. Please find my file attached.

Basically I want to see the intersection of leaf1 and leaf2 on "Result" text box.

Thanks!

Veronica

Employee
Employee

Re: Transfering the Intersection of Selections Using Alternate States

You had done it correctly.  The issue is you have other selections that are resulting in there not being an intersection.  Specifically the "Did" field in leaf1 state it is set to "Create" and in leaf2 state it is set to "Purchase".   Add current selections boxes for all states and then remove the selections on the Did field and 11113@gmail.com will return in your results.

Not applicable

Re: Transfering the Intersection of Selections Using Alternate States

Hi Josh

I just tried what you said and it did show up. But the thing is that I need to allow our users to choose from "Did", "What" and "Where" menu so that the pivotable will show up selected data. Is there anything we can do to allow people select everything they want on leaves and build the tree table based on previous selection?

I am also looking at p() and e(). Not sure how to insert alternate state into the set analysis with p() and e(). If you can provide some guidance that will be helpful.

Here is a reference link: P() & E() and where do you use them?

Thanks

Veronica

Not applicable

Re: Re: Transfering the Intersection of Selections Using Alternate States

Here is the original file again. Just for readers who didn't see the other post:

Inner Join, Outer Join, and Subtract between pivot tables

Employee
Employee

Re: Transfering the Intersection of Selections Using Alternate States

You could modify the expression so it doesn't consider some or all of your selector fields in leaf1 and leaf2.  For example:

=Concat(distinct{leaf1*leaf2<Did=>}UserEmail,'|')

Would not consider the Did field in leaf1 or leaf2.

Highlighted
Not applicable

Re: Re: Transfering the Intersection of Selections Using Alternate States

Josh, I just add that modifier in and it only shows leaf1, not the intersection.

See my attachment.

Also, could I know what formula to use for exclude? Is that 'state1/state2'?

Thanks

Veronica

Not applicable

Re: Re: Transfering the Intersection of Selections Using Alternate States

Josh, I want QlikView to consider all my 'Did', 'Where', 'What' selections... need to allow our users to choose from "Did", "What" and "Where" menu so that the pivotable will show up selected data. Is there anything we can do to allow people select everything they want on leaves and build the tree table based on leaves selection?

stevelord
Valued Contributor

Re: Transfering the Intersection of Selections Using Alternate States

Ahah!  The intersection of somethingdiblahbydibah was what I needed!  Asterisks!  I was banging my head looking for how to combine multiple states in a single EXPRESSION and everything everywhere I look is one state in each expression of some bar chart.

count(Distinct {[AR HA]*[AR Biometric]*[AR Incentive]} UserId)

I couldn't find this multi-state expression syntax anywhere else... unless it's past chapter 68 of the reference manual or buried under a misnamed thread somewhere else on earth...

phcaptjim
Contributor

Re: Transfering the Intersection of Selections Using Alternate States

Josh, this looks good.  thanks for posting this.

I'm going to try this except transferring the results back to my default state.  Question, does adding the select possible action after the initial selection slow down the process?  I'm doing this in a very large application where the user could be selecting thousands of options in each state so finding the intersection could be slow.  Nevertheless, I am going to try this and see how it works.