Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis... Help with this Multiple Condition please!

I'va a table with these dimensions:

1)Cliente

2)Descrizione Articolo

I've created two different expressions that calculate sales (vfatturatoAc)  and quantity (qfatturatoAC) for each client (cliente) and for specific category of product (N°Conto):

Sales: =Only({<[N° Conto]={"0501001*"}>}VFatturatoAC)

Quantity: =Only({<[N° Conto]={"0501001*"}>}QFatturatoAC)

My question is how can i calculate how many spare parts ([N° Conto]={"0501001*",0501002*"}) has bought those client who bought at least One of this product ([N° Conto]={"0501001*"}).

Hope to be enough clear.

Thanx.

Francesco.

10 Replies
Not applicable
Author

Table1: This is the chart with the correct data

Table 1.jpg

Table 2: This happen when i want to see how many spare parts has bought those client that has at least 1 Quantity

Table 2.jpg

As you can see comare some clients that has bought spare parts but has never bought 0501001.

thanx