topic Accumulated Values in Pivot Table in QlikView

Accumulated Values in Pivot Table

renuka_sasikumar — Fri, 26 Dec 2014 05:53:06 GMT

Hi,

I have MonthName as Dimension & expression are Budget, MTD, YTD, PYTD

For MTD (=Sum(Sales)) I m getting correct value, but when for YTD i have created variables to show data, but its not working.

Its giving the same MTD values.

I want to show Accumulated Values in Pivot Table & Range Sum is also not working.

Can anyone please help me with this.

Thanks & Regards,

Renuka S

amit_saini — Fri, 26 Dec 2014 06:02:14 GMT

Ranuka ,

Please share your qvw.

Thanks,
AS

PrashantSangle — Fri, 26 Dec 2014 06:04:28 GMT

Hi,

Try like

MTD =Sum({<DateField={">=$(=Date(Monthstart(Today())))"}>}Sales)

YTD = Sum({<Datefield={">=$(=Date(YearStart(Today())))"}>}Sales)

PYYTD= Sum({<DateField={">=$(=Date(AddMonths(YearStart(Today()),-12)))<=$(=Date(AddMonths(Today(),-12)))"}>}Sales)

Regards

amit_saini — Fri, 26 Dec 2014 06:09:17 GMT

Check:

Thanks,
AS

Fri, 26 Dec 2014 17:16:52 GMT

Can you attach the sample file.

so that we can help you in better way.

Sub2u