Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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-
Hi ,
Can you brief your requirement with some examples.
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)
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-
Hi ,
Do you have Delivered items in Different column?
I mean how you are defining delivered Items, Attach some sample data please.