topic Re: How to sum 2 column with currency ? in QlikView

How to sum 2 column with currency ?

paulyeo11 — Sun, 05 May 2013 13:17:32 GMT

Hi All

Expression 1 Current Asset :-

money(fabs(

Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"}

,[Reporting Code] = {

">=50010<=

50090"

}

, month = ,year=>}[Amount]/1000))

, $(vCurrencyFormatK))

Expression 2 Fixed Asset :-

money(fabs(

Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"}

,[Reporting Code] = {

">=20006<=

20061"

}

, month = ,year=>}[Amount])/1000)

, $(vCurrencyFormatK))

Expression 3 Total Asset :-

money(fabs(

Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"}

,[Reporting Code] = {

">=50010<=

50090"

}

, month = ,year=>}[Amount]/$(Columndim89))/1000)

Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"}

,[Reporting Code] = {

">=20006<=

20061"

}

, month = ,year=>}[Amount]/$(Columndim89))/1000)

, $(vCurrencyFormatK))

My issue is why Expression 3 result i get null vlaue. where i go wrong ?

Paul

Re: How to sum 2 column with currency ?

alexandros17 — Sun, 05 May 2013 13:33:48 GMT

$(Columndim89) has non value so your division cause the mistakes ...

if the result of expression 3 is equivalemt to expr. 1 + expr. 2 you csn easily do in expression 3

Column(1) + Column(2)

hope it helps

Re: How to sum 2 column with currency ?

paulyeo11 — Sun, 05 May 2013 13:49:38 GMT

Hi Alexa

I am aware that about your propose syntax , but i need to move the coumn expression to another table , which is not go to work , so i hope some one can help me figure out why my total expression not work ?

Paul

Re: How to sum 2 column with currency ?

paulyeo11 — Mon, 06 May 2013 02:34:21 GMT

Hi All

I have check and add currency for my QV Doc, but i still unable to sum the Current asset and Fixed Asset amount using 2 expression sum up.

Hope some one can share with me where go wrong ?

Enclsoed my Q\V Doc

Paul

Re: How to sum 2 column with currency ?

paulyeo11 — Mon, 06 May 2013 02:35:00 GMT

enclsoe my QV doc. which include the Currency var.

Re: How to sum 2 column with currency ?

sivarajs — Mon, 06 May 2013 03:56:07 GMT

There was a syntax error after your fabs keyword you have missed a open bracket

Re: How to sum 2 column with currency ?

paulyeo11 — Mon, 06 May 2013 04:11:50 GMT

Hi Siva

Now i understand , because you remove the money commend on the 2nd expression. you remove 2 braket. and remove the 1 expression vcurrencyFormatK. therefore you need to add one more at the top.

Thank you very much.

Paul