Delivery vs Sales

[chan103148]

Hello. Need help.

How to show the sum of sales based on exact items that were delivered.

Like "apple to apple"  thing.

Thank you in advance. 

[mahaveerbiraj]

Hi ,

Can you brief  your requirement with some examples.

[anushree1]

I am not sure if my understanding is right, But if you are looking for getting the sales of a particular item try using set analysis like:

sum({<Item={'Apple'}>}Sales)

[RadovanOresky · Accepted solution]

Hi,

The construction of your Qlik data model is quite important - do you have everything in one table or do you have separate tables for Sales and a separate one for Deliveries?

If separate, then it's essential to have a correct field that associates them, like OrderNum or DocumentID.

Then I would suggest to create a simple boolean "flag" field that identifies all orders-items, that were delivered. This can be based on an existing delivery date or some status field - it's highly specific to the logic of your dataset.

With that you then can have a simple expression using SET analysis like:

sum( {< ItemIsDelivered_flag = {"TRUE"} >} Sales )

Hope this helps,

-RADO-

[mahaveerbiraj]

Hi , 

Do you have Delivered items in Different column? 

I mean how you are defining delivered Items, Attach some sample data please.