topic Re: Qlik Sense - Required solution to show Balance Column. in App Development

Qlik Sense - Required solution to show Balance Column.

Anoop_DXB — Sat, 16 Nov 2024 18:30:48 GMT

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.

Re: Qlik Sense - Required solution to show Balance Column.

tommyl — Wed, 10 Jun 2020 07:11:25 GMT

Hello,

What about

dimension: date

measure: aggr(sum(balance),date)

Regards,

Re: Qlik Sense - Required solution to show Balance Column.

Anoop_DXB — Wed, 10 Jun 2020 08:46:58 GMT

Not coming properly.

Re: Qlik Sense - Required solution to show Balance Column.

tommyl — Wed, 10 Jun 2020 09:33:01 GMT

Is it the same or some other things is problem?

Re: Qlik Sense - Required solution to show Balance Column.

Anoop_DXB — Wed, 10 Jun 2020 10:24:12 GMT

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

Re: Qlik Sense - Required solution to show Balance Column.

tommyl — Wed, 10 Jun 2020 13:44:26 GMT

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,