how to: set analysis or if statement

[josephinetedesc]

Locality	North	North	South	South	East	East	West	West	SE	SE	TOTAL	Total
Month-Yr	Jun 2015	Jun 2014	Jun 2015	Jun 2014	Jun 2015	Jun 2014	Jun 2015	Jun 2014	Jun 2015	Jun 2014	Jun 2015	Jun 2014
Cars sold	68	62	73	72	209	191	128	155	60	56	538	536
Cars Paid	61	70	60	62	204	183	133	156	67	43	525	514
if(location = 'North',(sum(Cars sold))
or
if(location = 'South',(sum(Cars sold))
or
if(location = 'East',(sum(Cars sold))
or
sum({$}(Cars sold))
)))))

I have a pivot table and Locality is a dimenstion -so how do I get the total in this case?  Even using the set analysis - i do not have a column for the Total - so i need to load a 'dummy' Locality?

Thank you

Jo

[jagan]

Hi,

To fix the charts you need to select

Chart Properties -> Layout-> Uncheck Allow Move/Size option.

You can attach the sample file by using Use Advance Editor option in the Reply section.

You are not getting the total because you are not selecting the Show Partial Sums option.

Regards,

Jagan.

[josephinetedesc]

Ah ... the Show Partial sums option works for ONE Month and ALL Campuses

but not when there are 2 months Jun2014 and Jun 2015 and ALL Campuses.

Sorry about the images - but I am paranoid about privacy issues!

[jagan]

You need to select partial sums for all the dimensions.  If you are using Calculated Dimension move it to script and use the new field in the chart.

Regards,

Jagan.

[qlikviewwizard]

josephinetedesco‌

Can you close the thread if you get the answer?