topic Re: How to use expression to replace my 12 expression ? in QlikView

How to use expression to replace my 12 expression ?

paulyeo11 — Sat, 11 May 2013 07:24:03 GMT

Hi All

My below expression working fine :-

=money(fabs(

Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-12),'YY MMM'))"}, month = ,year=>}[Amount]/1000/$(Columndim89)))

, $(vCurrencyFormatK))

I need to use 12 expression for display 12 column data. Table (A) refer to enclosed Table .

My question it is possible to replace one expression instead of 12 expression ?

Paul

Re: How to use expression to replace my 12 expression ?

calvindk — Sun, 12 May 2013 16:46:00 GMT

You could try and make it into a pivot, and use monthyear as extra dimension (pull it to top).

Then you should be able to reduce it to one expression, although i dont have time to sort out the expression right now.

Best wishes

Re: How to use expression to replace my 12 expression ?

paulyeo11 — Mon, 13 May 2013 01:40:03 GMT

Hi Andres

Many thank to response on my post. Yes I manage to get it work base on yr proposal. But now I need at once more diamension on balance sheet field that is GL DESC. can you share with me how ?