Striaght table expression change to Pivot table pr... - Qlik Community

paulyeo11 · ‎2013-05-13

Hi All

I have a expression which will give me the Inventory stock amount for march 2013, when user select on month=march year=2013 :-

=money(fabs(

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

, $(vCurrencyFormatK))

if i need to get the Feb 2013 inventory stock amount , i need to change the above expression to the -0 , change it to -1, it work fine.

My issue is very troublesome , i need to create 12 expression if i want to display last 12 month inventory stock amount.

I have learn from Mr Andres , i can achieve this thru pivot table , see the post on below link :-

i did try his approach by add YearMonth to siamension , and change the table to pivot table , and pull the YearMonth to the top,

but the amount are not correct. ( See my enclosed QV sample Table 2 March 2013 result is different from Table 1 march 2013. )

Paul

Striaght table expression change to Pivot table produce wrong result.