calculation error

[yadav_anil782]

HI qlik experts,

i'm  giving  this expresion  to calculate Balance Amount -

=(([Received Collection]+[Future Collection])-([Paid Amount]+[Future amount])))+Alt(Above([Net  Amount]),0)

but i need to calclate "Future amount " from current day

so with the currect day variable "vtoday"(let vtoday = today()) i changed calculation

so now expresion is=(([Received Collection]+[Future Collection])-([Paid Amount]+(vtoday>=[Planned Projects  Outflow])))-Alt(Above([Net  Amount]),0)

but result is not correct

Year	Received Collection	Future Collection	Paid Amount	Future amount
2010	1,421.04	0	1107.098245	0.00
2011	441.75	0	475.4609762	0.00
2012	651.47	0	553.9400598	0.00
2013	868.57	0	708.9294924	588.64
2014	1,327.17	0	1195.169367	450.52
2015	409.84	189.8604829	462.213479	644.23
2016	0.00	448.5047963	0	897.06
2017	0.00	142.3916334	0	448.40
2018	0.00	72.15202794	0	256.26
2019	0.00	29.59615234	0	9.10

[sushil353]

Hi,

what is this condition: vtoday>=[Planned Projects  Outflow]

[yadav_anil782]

vtoday is variable , i'm putting for take more then current date value from "Future amount"

but i'm not getting currect value from this

[jafari_ervin]

Hi,

Please upload your sample Qvw File.

Best,

[Kushal_Chawda]

Try,

=(sum([Received Collection])+sum({<[Planned Projects  Outflow]={">=$(vtoday)"}>}[Future Collection]))-(sum([Paid Amount])+sum({<[Planned Projects  Outflow]={">=$(vtoday)"}>}[Future Collection]))-Alt(Above([Net  Amount]),0)

make sure that Format of vtoday should match with [Planned Projects  Outflow]

[yadav_anil782]

app size is too big,  i' again  repeting things which i 'm facing to develop.

i'm using this table  and i want a new coumn "balance amount". for that i need to calculate  (collection- amount)

in this table  there are 4 coumn - two column belong to collection and another two column belongs to amount

logic is  current (collection+ future collection )-(paid amount+ future amount)) but future amount i need to calculate only form current system date after then  it will be call future amount

so now expresion is=(([Received Collection]+[Future Collection])-([Paid Amount]+(vtoday>=[Future amount])))-Alt(Above([Net  Amount]),0)

here vtoday is variable , i dont know its giving morethen today future amount  or not but my  result is coming wrong

Year	Received Collection	Future Collection	Paid Amount	Future amount
2010	1,421.04	0	1107.098245	0.00
2011	441.75	0	475.4609762	0.00
2012	651.47	0	553.9400598	0.00
2013	868.57	0	708.9294924	588.64
2014	1,327.17	0	1195.169367	450.52
2015	409.84	189.8604829	462.213479	644.23
2016	0.00	448.5047963	0	897.06
2017	0.00	142.3916334	0	448.40
2018	0.00	72.15202794	0	256.26
2019	0.00	29.59615234	0	9.10

[yadav_anil782]

"planned project out flow"and "future collection" column is same  there are only 4 column which i shared in table

[qlikmsg4u]

What is your date column to compare today date variable? with out date column how can you get Future Amount for today date?

[Kushal_Chawda]

There should be some Date to compare with vToday. Put that date in place of planned project out flow in my expression

[yadav_anil782]

i have date in my data modling and i'm puting variable form that date . i need  healp only in scipt error which is wrong