topic Re: rangesum(above( Expression get error only on table in QlikView

rangesum(above( Expression get error only on table

paulyeo11 — Wed, 08 May 2013 01:37:41 GMT

Hi All

Below expression give me Balance sheet current liability amount for current month and year which display on Table. ( working fine ).

money(fabs(

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

,[Reporting Code] = {

">=70010<=

70070"

}

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

, $(vCurrencyFormatK))

In order for me to view the last 6 month trend on current liability , i modify the above table by change the diamension from SOURCE to YearMonth. and change the table to line chart.

it display correct. and change the expresison from above to below ( Thank to stefan last time teach me how to make use of rangesum ) :-

rangesum(above(

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

,[Reporting Code] = {

">=70010<=

70070"

}

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

,0,rowno()))

Now i wanted to view the Table amount for last 6 month current liability instead from line chart , i need to view from table. i convert the above to table instead of chart.

I get the result wrong , can some one tell me why ?

Paul

Re: rangesum(above( Expression get error only on table

paulyeo11 — Wed, 08 May 2013 08:01:04 GMT

Any one can offer me help ?

Re: rangesum(above( Expression get error only on table

orital81 — Wed, 08 May 2013 08:22:38 GMT

Hi Paul

When I convert to table I see the same results.

(See attached - table 3). Please clarify - where do you see the gap?

Re: rangesum(above( Expression get error only on table

paulyeo11 — Wed, 08 May 2013 10:08:54 GMT

Hi Sir

Thank you very much for your advise. Now i need to move one more step further.

That is i wanted to have table display by SOURCE_GL and display the monthly liability.

Meaning i wanted to view TDSPG and TDSID the monthly liability amount.

you notice that now Table 3 can display individual SOURCE_GL current liability.

But Table 6 display the amount wrong , how to make it display same as table 3.

By the way Table 6 vs table 3 only different is table 6 i Add SOURCE_GL field at diamension.

Paul

Re: rangesum(above( Expression get error only on table

paulyeo11 — Wed, 08 May 2013 14:54:14 GMT

Enclosed my QV Doc, hope some one can advise me.