topic Re: Pivot table expressions in QlikView

Pivot table expressions

Wed, 19 Aug 2015 14:33:58 GMT

Hi Qlikview Friends

I hava a data as fallows

	Jan	Feb	Mar	Apr	........	Dec
Count1	200	120	235	460	.........	301
Count2	150	112	183	340	......	209
Count3	120	130	139	120	....	127
YTD	470	362	557	920		637

Count1 = Count(Field)

Count2 = Count(Field)

Count3 = Count(Field)

with different conditions

YTD = Sum(Count1, Count2, Count3)

but I want as fallows

	Jan	Feb	Mar	Apr	........	Dec	YTD
Count1	200	120	235	460	.........	301	1316
Count2	150	112	183	340	......	209	994
Count3	120	130	139	120	....	127	636et

I can get this using partial ''sum option with Month'' but it always comes 'TOTAL' as Title , different colour, bold font etc

but I want just YTD as title same as other expressions

I tried count1, count2.count2 expressions horizontally , YTD expression as vertically but its not coming all expressions either coming vertically or horizontally .

can we make some expressions vertically and some expressions horizontally in pivot table please advice me

Re: Pivot table expressions

chaper — Wed, 19 Aug 2015 15:32:53 GMT

Use partial Sum and change the label for TOTAL..See below

Re: Pivot table expressions

chaper — Wed, 19 Aug 2015 15:34:57 GMT

Also check this link.Pivot Table SubTotals when a Dimension determines Expression Calculation .Good example provided by stevedark‌ for customising Pivot table Totals

Re: Pivot table expressions

Wed, 19 Aug 2015 15:45:40 GMT

Thanks You,

but is it doable , like some expressions as vertically , some as horizontally in single pivot table

Regards

NKummari

Re: Pivot table expressions

chaper — Wed, 19 Aug 2015 15:56:01 GMT

NO for Expressions.But YES for Dimensions

Re: Pivot table expressions

chaper — Wed, 19 Aug 2015 15:58:41 GMT

Check this it may help you how to get one expression horizontal and one vertical in pivot table?