Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
JohanSOL
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 (1)
1 Reply
Yoshidaqlik
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