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,

You can try Show Partial Sums option in the Presentation tab to display the total.  Select Partial Sum option for all the dimensions and check.

Regards,

Jagan.

[josephinetedesc]

Hi Jagan

is that in Presentation tab?  I am using a pivot table - i cannot see  Select partial sums in version 11???

jo

[#4]

Hi Josephine,

In what format are you getting your input data?

Could you please elaborate?

Regards,

Jemimah

[jagan]

Hi,

In presentation tab of Pivot table properties Show Partial Sums option is available.  I think QV9 it is available, can you attach a sample file or screenshot of that tab.

Regards,

Jagan.

[josephinetedesc]

Hi Jemimah

my input data comes from a database and an excel sheet.  The database has daily values, the spreadsheet has the Localities

Jo

[josephinetedesc]

[qlikviewwizard]

Hi josephinetedesco,

You have to set the data as shown in attached file.

Later use the below script and create Pivot table. No need to use set analysis.

Hope it will help you.

Data:

load * ,Date([Month-Yr]) as Date;

LOAD Locality,

    [Month-Yr],

    [Cars sold],

    [Cars Paid]

FROM

if_in_set_analysis.xlsx

(ooxml, embedded labels, table is Data);

[PrashantSangle]

Hi,

Show Partial Sum enable after selecting Dimension.

Regards,

[jagan]

Hi,

Click on the Dimension and select the Show Partial Sum option.  If you attach the sample then it would be easier to provide the solution.

Regards,

Jagan.