topic Re: Help to add YTD & MTD in Pivot Table in QlikView

Help to add YTD & MTD in Pivot Table

SatyaPaleti — Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

Could some one can please help me How can we add YTD & MTD in the bottom of the Pivot table.

I am showing Jul and August Sales and in September I have to show all the dates Sales. So I need two total at bottom one is Totals for all the months and one is Total for all the Days. As per below screenshot

Please find attached documents for sample qvw and sample data

Thanks and Regards,

Satya

Re: Help to add YTD & MTD in Pivot Table

qliksus — Tue, 25 Sep 2018 05:31:32 GMT

Just add dummy dimension and use the below expression

Dim1 : ''

Dime2 : Month ............etc

Expr: if( Dimensionality() = 1 , Sum({<Month={'Sep'}>}Sales) ,

if( Dimensionality() = 0 , Sum({<Month=-{'Sep'}>}Sales) ,
sum(Sales) ) )

You can use dynamic month based on your requirement in the filter

Re: Help to add YTD & MTD in Pivot Table

uacg0009 — Tue, 25 Sep 2018 07:45:57 GMT

Hi Satya,

For pivot table, there is function in Presentation tab called show partial sums.

You can check it in your month and Date column, then you will see the total that you need.

Thanks.

Aiolos

Re: Help to add YTD & MTD in Pivot Table

SatyaPaleti — Wed, 26 Sep 2018 08:48:15 GMT

Hi Susanth,

Thank your reply. Can you please create sample qvw and forward to me

Thanks and Regards,

Satya