topic Re: Pivot table issue in QlikView

Pivot table issue

Thu, 27 Apr 2017 08:16:40 GMT

Hi all,

I have small issue with pivot table please assist me,

i have a two expressions like "actual" and "actual%". and i my dimension "Period".

if i select Period 1 the following data is displaying

Actual Actual%

Gross revenue 100000 100%

if i select Period 1,2,3 at a time with list box filter the following values are displaying.

Period1 Actual Actual% Period2 Actual Actual% Period3 Actual Actual%

Gross revenue 100000 31.08% 120000 34.01% 1400000 34.91%

I want to display actual% also 100% each period like the following

Period1 Actual Actual% Period2 Actual Actual% Period3 Actual Actual%

Gross revenue 100000 100% 120000 100% 1400000 100%

Re: Pivot table issue

rahulpawarb — Thu, 27 Apr 2017 08:20:34 GMT

Hello Raja,

Trust that you are doing good!

Given requirement is ambiguous to me. Could you please share the application or share the expression definitions? This will help us to further analyze the issue and provide you expected response.

Regards!

Rahul

Re: Pivot table issue

Thu, 27 Apr 2017 08:28:43 GMT

find my screen shot, i think so this is helpful

Re: Pivot table issue

Anonymous — Thu, 27 Apr 2017 08:35:00 GMT

What is the value of vRev??

Re: Pivot table issue

Thu, 27 Apr 2017 08:40:38 GMT

vREV = 16029213

Re: Pivot table issue

Thu, 27 Apr 2017 08:45:28 GMT

vREV is different period to period

u can find it above screen shots, and actual is dispalying correct values but actual% is not like that it disaplys the value is "actual% / period number"