Pivot table - need expression in one column

Fri, 21 Sep 2012 12:32:57 GMT

Hello,

Can you help me figure out a way to display the % change in only the last column rather than every column. The user will select the YR_Qtr range they want to see so this is dynamic.

There are two expressions for this Pivot Table: #1 Sum(Cases) and #2 (sum(Cases) - rangesum (before(Sum(Cases))))/rangesum (before(Sum(Cases))))

I just want to show the percent change for the last two quarters that the user selects in any given range. Thanks!

YR _Qtr	2011Q1		2011Q2		2011Q3		2011Q4
Facility	Cases	%Change	Cases	%Change	Cases	%Change	Cases	%Change
Hospital A	64939	-	66698	2.71%	61052	-8.47%	65303	6.96%
Hospital B	17044	-	17144	0.59%	17082	-0.36%	16317	-4.48%
Hospital C	12867	-	12506	-2.81%	12917	3.29%	12526	-3.03%
Hospital D	13947	-	13750	-1.41%	14316	4.12%	14253	-0.44%
Hospital E	45832	-	43175	-5.80%	42334	-1.95%	43979	3.89%

Re: Pivot table - need expression in one column

swuehl — Fri, 21 Sep 2012 13:33:00 GMT

I don't think it's possible to hide expression columns for certain horizontal dimension values (you can probably set the outcome to not showing results, but that would still leave some empty columns).

But you can try using a total (i.e. partial sum in pivot tables) column, checking for the total columns using secondarydimensionality() in your expression and applying a special expression to only consider previous two columns for your % change.

topic Re: Pivot table - need expression in one column in QlikView

Pivot table - need expression in one column

Re: Pivot table - need expression in one column