Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Creating multiple totals by year by quarter in pivot table

I'm trying to take a series a data into a summary table. (to keep things simple [Smiley Happy] ) I have a date field and a quantity field and need to produce a summary of this data by quarter by year using pivot tables.

I would like it to look something like the following

2010

2011

{total for all of 2010}

{total for all of 2010}

Jan-Mar 2010

Apr-Jun 2010

Jul-Sep 2010

Oct-Dec 2010

Jan-Mar 2011

Apr-Jun 2011

Jul-Sep 2011

Oct-Dec 2011

{Q1 total}

{Q2 total}

{Q3 total}

{Q4 total}

{Q1 total}

{Q2 total}

{Q3 total}

{Q4 total}



Mine usually ends up close to this but usually falls over on the yearly totals, I've tried putting multiple expressions and using partial sums but to no avail.

Many many thanks in advance for any help anyone can offer me.

Maria

1 Solution

Accepted Solutions
fernandotoledo
Valued Contributor

Creating multiple totals by year by quarter in pivot table

See the example atached. Shows both solutions.

Hope it helps!

Thanks ; ) !

Fernando

4 Replies
fernandotoledo
Valued Contributor

Creating multiple totals by year by quarter in pivot table

You can use a calculated dimention to do that, but the best performance would be using Presentation>Show Partial Sums for the Quarter dimension.

Hope it helps

Best regards

Fernando

Not applicable

Creating multiple totals by year by quarter in pivot table

Thanks for the reply Fernando.

I have yearname(datefield) and quartername(datefield) in my expressions and I've ticked the partial sums. This gives me a total for the year but puts it to the right of the quarter totals. This is not what my boss wants and would like the totals under the year.

I know it is trivial but he wants it to look like it did on Excel originally!

Maria

fernandotoledo
Valued Contributor

Creating multiple totals by year by quarter in pivot table

See the example atached. Shows both solutions.

Hope it helps!

Thanks ; ) !

Fernando

Not applicable

Creating multiple totals by year by quarter in pivot table

Thanks Fernando, worked like a charmBig Smile

Community Browser