Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
petergassert
Contributor III
Contributor III

Create Timeline in linechart with 2 measures in one line with a combined x achsis

Hi,
i am stuck with a creating a linechart.
I git a bankaccount table that tells me the saldo different companies got at the end of month.

Saldo:
Load * inline [
Company,Date,Amount
Company 1,31.01.2021,200
Company 1,28.02.2021,150
Company 2,31.01.2021,100
Company 2,28.02.2021,140];

The amount refelcts the Saldo the company got  on a selected date.

During a month the companies got transactions that will cause a change in the amount on the respective date end of the month. 

Transactions:
Load * inline [
Company,Date,TransactionAmount
Company 1,05.02.2021,10
Company 1,10.02.2021,-20
Company 1,15.02.2021,-30
Company 1,27.02.2021,-10
Company 2,06.02.2021,-20
Company 2,11.02.2021,10
Company 2,16.02.2021,40
Company 2,28.02.2021,10];

The transaction amount reflects all transactions within the month.

Aim is to create a timline in a linechart, always starting with the selected Saldo and all transactions will be cumulated with all values shown before.

petergassert_0-1615977952170.png

 

Question :
How do i link both tables best?
How do i make sure, that the values of saldo and transactions will be in one measure?
How do i make sure, that further upcomming saldos, as i select one in the past, will be ignored?
How  i cumulate in this case best? Rangesum(Abouve(..) or Sum({<Date={">=Saldodate"}>} Date)

Thanks and best regards,
Peter

0 Replies