Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Crossed sales

Hi,

I'm trying to know, with a set analysis calculation, the next:

When the user select a Product, show a table with the detail of products that has been solded in the same Order than the product I have been selected, and the number of coincidences (number of orders).

Is it possible to do with set analysis?

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Crossed sales

with Product as Dimension:

 

count( DISTINCT {1< OrderId=P( {$} OrderId) >} OrderId)

 

View solution in original post

2 Replies
Highlighted
Partner
Partner

Re: Crossed sales

Hi,

try with something like this:

sum({<order={'$(=Max(order))'},product=>}1)

Highlighted
Partner
Partner

Re: Crossed sales

with Product as Dimension:

 

count( DISTINCT {1< OrderId=P( {$} OrderId) >} OrderId)

 

View solution in original post