Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Tables

I have something like this in raw data:

Full Text Reason CodeDays Bucket Amount
101 - Cash Application Issue16-30 Days10
101 - Cash Application Issue16-30 Days20
101 - Cash Application Issue16-30 Days30
101 - Cash Application Issue16-30 Days40
101 - Cash Application Issue1-15 Days50
101 - Cash Application Issue1-15 Days15
101 - Cash Application Issue1-15 Days25
100 - Please Select16-30 Days35
100 - Please Select1-15 Days2
100 - Please Select16-30 Days3
100 - Please Select16-30 Days4

That I want to display like this in a report table:

(Count Days Bucket)(Sum of Amount)
Row Labels1-15 Days16-30 Days1-15 Days16-30 Days
100 - Please Select13242
101 - Cash Application Issue3490100

The first part of having the (Count Days Bucket) Columns is done. Now I need to repeat those columns on the right, for the Sum of Amount.

Also I want it done in a way that if I add new rows with new periods of days, it automatically add's a new column to the report table, like in Excel.

Message was edited by: Miguel Domingos 2013-10-14 at 14h11m GMT

1 Solution

Accepted Solutions
rustyfishbones
Master II
Master II

Just click and drag until you get the format you want

here is a file with it done

View solution in original post

5 Replies
bbi_mba_76
Partner - Specialist
Partner - Specialist

Hi,

you have to add the show partials sums in the presentation tab

Not applicable
Author

The partial sums shows totals, does not repeat the same columns to the right.

bbi_mba_76
Partner - Specialist
Partner - Specialist

Sorry, but adding the second expression you have what you want.

rustyfishbones
Master II
Master II

Just click and drag until you get the format you want

here is a file with it done

Not applicable
Author

Yes but I should drag the lines not the columns as I was doing.