Skip to main content

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 
Not applicable

calculated feild


I am trying to import data from a csv file which have is similar to following table:


This file already contains first five columns of table shown above. I need a calculated field "Sales Amount" which should be calculated like :

Sales Amount = (Qty x Price ) + Postage

But Problem i was facing is that for orders in which there are multiple skus/items for example order id 1002, in which there are two skus/items (i.e S001, S002). Even though customer has paid only $6 Postage it's showing against both items which results into inflating the total "Sales Amount". In excel we can use following formula to resolve the issue and divide the postage equally to all skus/items :


I am wondering how i can achieve the same in Qlikview dataload editor script, Appreciate if someone can help/guide me.


11 Replies

I apologize for the inconvenience, but would you be able to share this as an Excel file?

Uploading a Sample

Not applicable


i have almost resolved the problem, need one little help can you guide my how can i convert this "measure" calculation code to data load editor code :

([Carriage Amount]/Count(DISTINCT TOTAL <[Order ID]> [SKU]))

so I can load it as calculated field instead of a measure.