topic Re: Delivery vs Sales in App Development

Delivery vs Sales

chan103148 — Fri, 26 Jul 2019 01:38:38 GMT

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.

Re: Delivery vs Sales

mahaveerbiraj — Fri, 26 Jul 2019 07:00:57 GMT

Hi ,

Can you brief your requirement with some examples.

Re: Delivery vs Sales

anushree1 — Fri, 26 Jul 2019 08:58:15 GMT

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)

Re: Delivery vs Sales

RadovanOresky — Fri, 26 Jul 2019 09:29:44 GMT

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-

Re: Delivery vs Sales

mahaveerbiraj — Fri, 26 Jul 2019 09:30:01 GMT

Hi ,

Do you have Delivered items in Different column?

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