Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
josephinetedesc
Contributor III

how to: set analysis or if statement

LocalityNorthNorthSouthSouthEastEastWestWestSESETOTALTotal
Month-YrJun 2015Jun 2014Jun 2015Jun 2014Jun 2015Jun 2014Jun 2015Jun 2014Jun 2015Jun 2014Jun 2015Jun 2014
Cars sold686273722091911281556056538536
Cars Paid617060622041831331566743525514
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

23 Replies
MVP & Luminary
MVP & Luminary

Re: how to: set analysis or if statement

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
Contributor III

Re: how to: set analysis or if statement

Hi Jagan

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

jo

Not applicable

Re: how to: set analysis or if statement

Hi Josephine,

In what format are you getting your input data?

Could you please elaborate?

Regards,

Jemimah

MVP & Luminary
MVP & Luminary

Re: how to: set analysis or if statement

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
Contributor III

Re: how to: set analysis or if statement

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
Contributor III

Re: how to: set analysis or if statement

capture.JPG

qlikviewwizard
Honored Contributor II

Re: how to: set analysis or if statement

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);

Re: how to: set analysis or if statement

Hi,

Show Partial Sum enable after selecting Dimension.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
MVP & Luminary
MVP & Luminary

Re: how to: set analysis or if statement

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.