topic Re: Problem with creating a pivot table in QlikView

Problem with creating a pivot table

Wed, 21 May 2014 13:32:43 GMT

I am fairly new to qlikview and I am trying to create a pivot table that will look something like this:

Quarter 1 2014 Quarter 4 2013

Domestic| International | Total Domestic|International | Total

Division

ABC

DEF

The records that I have coming in

Year,

period (this would be the month of the sale),

Area (this would be 'DOM' for Domestic or 'INT' for International),

Division

Amount

I think my problem is splitting out the Domestic & International; not sure how to get it to split out like this.

Any help is appreciated.

Wed, 21 May 2014 13:41:47 GMT

Can you post your qvw or datasource file?

Wed, 21 May 2014 13:45:59 GMT

For your dimensions use Year, Period, Area, Division

For your expressions use Amount

lironbaram — Wed, 21 May 2014 13:50:44 GMT

have a look at the attach example

Wed, 21 May 2014 13:55:28 GMT

This is what my data would look like from the load

Wed, 21 May 2014 14:05:43 GMT

Perfect!!! Exactly what I was looking for!!!!

Thank you!!!!

Wed, 21 May 2014 14:26:02 GMT

How did you get the columns to line up that way????

I am trying to drag & drop but it doesn't seem to work.

Also I would like to add at the bottom the following:

Int'l % of Total

lironbaram — Wed, 21 May 2014 14:35:12 GMT

hi you need to select the 3 dimension you want

and then to pivot the dimension you want to display horizontal

just drag the dimension label upward

i am attaching example with your data