How to display sub-total without change Table total in pivot table?

Sat, 13 Dec 2014 07:08:31 GMT

Hi,

I created pivot table in qlik view , i took 2 Dimensions,1 .country ,2.city dimensions, after wrote expressions like this 1.sum( sales)

2.sum(sales) / sum( Total sales) 3.sum(sales)/sum(total<Country>sales) ater I displayed pivot table with sub-totals but But in my pivot table when I selected city name in List box the Pivot table show city sub-total value at the same time change the povot table total value.I do not want change pivot table total value. I want to display like this i.e 1.If I select one city name in List box the pivot show city sub-total at the same not change the Pivot table total value.ple tell me out how to display sub total at the same time not change Pivot Total value.

Example:

List box

City
Banglore
sanfrancisco
London

Pivot table

Country	City	Sales
America	San francisco	30000
sub-total		30000
Uk	London	40000
sub-Total		40000
India	Banglore	50000
Sub-Total		50000
Total		120000

if i select city Banglore in List box the pivot table shows like this

Country	City	Sales
India	Banglore	50000
sub-total		50000
Total		50000

I do not want to display the pivot table Like above table.

I want to Display Pivot table like this .If i select City banglore the pivot table show sub total(Sales:50000) and does not change the total(Sales:120000) value.

Country	City	Sales
India	Banglore	50000
sub-total		50000
Total		120000

ple tell me out How to display like above table .

thank you,

Regards;

Madhu

Re: How to display sub-total without change Table total in pivot table?

ecolomer — Sat, 13 Dec 2014 07:27:25 GMT

select subtotals in the label presentation, selecting element and selecting subtotals

Re: How to display sub-total without change Table total in pivot table?

Sat, 13 Dec 2014 08:28:07 GMT

I do not understand can you explain with small example Enrique.

Thank you,

regards,

madhu

Re: How to display sub-total without change Table total in pivot table?

greg-anderson — Sat, 13 Dec 2014 09:07:19 GMT

Hi, Madhu. You can use set analysis to configure an expression to ignore selections.

In this example, Sum({<[Country]=, [City]=>} Total Sales) will create a "Total Sales" field that ignores all selections in the City and Country dimensions.

QVW attached. Cheers!

topic How to display sub-total without change Table total in pivot table? in QlikView

How to display sub-total without change Table total in pivot table?

Re: How to display sub-total without change Table total in pivot table?

Re: How to display sub-total without change Table total in pivot table?

Re: How to display sub-total without change Table total in pivot table?