Pivot Table

upaliwije — Thu, 24 Apr 2014 10:05:34 GMT

I have created a document (demo) with two Pivot Table .

Table 1 shows data monthly data (both Row & Columns)

Table 2 shows data in monthly columns with one row.

Relationship between these two tables are as follows

In the table 2 data is shown

Under JAN_NRP 4,122,270 (Data from table 1 under JAN_NRP column in the Month 1 row)

Under FEB_NRP 5,225,041 (Data from table 1 under FEB_NRP column in the Month 2 row)

Under JUN_NRP 3,978,719 (Data from table 1 under JUN_NRP column in the Month 6 row) etc

However from Column AUG_NRP onwards this is not working Properly. Eg Under AUG_NRP column (table 2) figure shown is 4,327,208 but correct figure should be 4773933.

I have attached my document and pls help me to rectify this

Re: Pivot Table

hic — Thu, 24 Apr 2014 15:50:57 GMT

You are making it much too complicated. Do the following:

1) Load the data using the Crosstable prefix:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable

Crosstable (Month, Amount)

Load Year,

JAN_NRP as Jan,

FEB_NRP as Feb, ...

2) Create a pivot table with Year and Month as dimensions and Sum(Amount) as expression.

3) Sort Month according to Load order.

4) Drag and drop the header of "Month" to become a horizontal dimension.

HIC

topic Re: Pivot Table in QlikView

Pivot Table

Re: Pivot Table