topic Re: calculation error in QlikView

calculation error

yadav_anil782 — Thu, 23 Jul 2015 05:00:13 GMT

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

Re: calculation error

sushil353 — Thu, 23 Jul 2015 05:42:56 GMT

Hi,

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

Re: calculation error

yadav_anil782 — Thu, 23 Jul 2015 05:46:31 GMT

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

Re: calculation error

jafari_ervin — Thu, 23 Jul 2015 05:50:30 GMT

Hi,

Please upload your sample Qvw File.

Best,

Re: calculation error

Kushal_Chawda — Thu, 23 Jul 2015 05:58:11 GMT

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]

Re: calculation error

yadav_anil782 — Thu, 23 Jul 2015 06:09:55 GMT

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

Re: calculation error

yadav_anil782 — Thu, 23 Jul 2015 06:20:43 GMT

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

Re: calculation error

qlikmsg4u — Thu, 23 Jul 2015 06:27:13 GMT

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

Re: calculation error

Kushal_Chawda — Thu, 23 Jul 2015 06:28:53 GMT

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

Re: calculation error

yadav_anil782 — Thu, 23 Jul 2015 09:31:49 GMT

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