topic Pivot table issue in QlikView

Pivot table issue

Wed, 04 Feb 2015 11:58:40 GMT

Hi,

I am new to qlikview. Can you please help me to solve my issue. I am attaching .qvw file for your reference. In Table 1 values are showing correctly. In Table 2 (Though it is same except I have replaced 'product' with 'revenue Repertoire' field in dimension.

Your help highly appreciated.

Regards,

Suhas

Re: Pivot table issue

rubenmarin — Wed, 04 Feb 2015 12:28:31 GMT

Hi Sushas, when showing by revenue the expression won't work because there are more than one value for fields like Relase Date.

If you want a sum of the products in each 'revenue Repertoire' one option can be tell qv to calculate the sum of each produt and YYYYMM using aggr(), in example:

Frontline: =sum(aggr(if (ReleaseDate <= MakeDate(Left(YYYYMM,4),Right(YYYYMM,2)) AND ReleaseDate >= AddMonths(MakeDate(Left(YYYYMM,4),Right(YYYYMM,2)),-11), sum({<[Source]={'SME'},[Prod Type Desc]={'RBT'},[Revenue Repertoire]=>}Quantity))/100, [Revenue Repertoire], Product, YYYYMM))

Catalouge: =Sum(aggr(if (ReleaseDate <= AddMonths(MakeDate(Left(YYYYMM,4),Right(YYYYMM,2)),-12), sum({<[Source]={'SME'},[Prod Type Desc]={'RBT'}>}Quantity))/100, [Revenue Repertoire], Product, YYYYMM))

Hope this helps.

Re: Pivot table issue

Wed, 04 Feb 2015 12:38:49 GMT

Thanks Ruben for your prompt response.