topic Re: Crossed sales in QlikView

Crossed sales

Adrian1 — Mon, 26 Jan 2026 18:19:17 GMT

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?

Re: Crossed sales

StarinieriG — Fri, 18 Oct 2019 09:00:21 GMT

Hi,

try with something like this:

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

Re: Crossed sales

Adrian1 — Fri, 18 Oct 2019 10:33:55 GMT

with Product as Dimension:

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