Qlik Sense - Required solution to show Balance Column.

[Anoop_DXB]

Hi Guys,

Greetings to All 

How i can show balance column in line diagram. I need to present daily balance but if i have more than one entry in same date then my chart result will be wrong. How i can solve this and which function can use for this situation.

Dimension: Date  & Measures: Balance.

Date	Chq. No.	Debit	Credit	Balance
1-Apr-20				176837.02
1-Apr-20	44		15,950.00	160,887.02
5-Apr-20	675		20,000.00	140,887.02
2-Jun-20	6754		31,500.00	109,387.02
2-Jun-20	980	25,000.00		134,387.02
13-Jun-20	1014		200,000.00	(65,612.98)
13-Jun-20	100072	3,500.00		(62,112.98)
10-Aug-20	778		3,600.00	(65,712.98)
10-Aug-20	1041		670,000.00	(735,712.98)
30-Oct-20	399		56,260.00	(791,972.98)
30-Oct-20	419		56,260.00	(848,232.98)

 Please solve for me.

Thanks in Advance.

[tommyl]

Hello,

What about

dimension: date

measure: aggr(sum(balance),date)

Regards,

[Anoop_DXB]

Not coming properly.

[tommyl]

Is it the same or some other things is problem?

[Anoop_DXB]

Still faced the same problem. 
If more than one entry in the same date then system showing cumulative amount.

[tommyl]

Hello, as far as i know if you dont have timestamp value with hh:mm:ss or sth to differentiate the date values, you will always see the sum of the balance for a single date. 

Regards,