Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Add manual data/values to script with data load from database

Hi,

I have a scipt where I load all revenue/volumes/categories from our booking systems database. I'm now trying to add an variable price to this and need to do this manually since it does not exist in the booking system. What I want to trigger is when cargo A in harbour X is being transported this triggers an varible cost of Y$.

So my question is how can I add the cost of Y$ to the existing categories I have loaded from the database and create relationship between them, transported cargo A x Y$ = total variable cost for cargo / customer

Many thanks for the help!

Br,

Johan

 

Labels (2)
1 Reply
Highlighted
Creator II
Creator II

Hi

Does this calculation need to be done a right data load?

you can use the "Resident" to do an analytical analysis and create a linked backing sheet

Something like

Table_1:
Load
 Gate,
 Value
From source;

Table_2
Load
Gate,
if(Sum(Value) > 20,2,3) as Cost_Variable
Resident Table_1
Group By Gate;

 

Hope this helps

regards

YoshidaQlik https://www.youtube.com/channel/UC1I9P8MqCZEhB6Nw3FdSqng