Convert tables

[#1]

I have something like this in raw data:

Full Text Reason Code	Days Bucket
101 - Cash Application	16-30 Days
101 - Cash Application	16-30 Days
101 - Cash Application	16-30 Days
101 - Cash Application	16-30 Days
101 - Cash Application	1-15 Days
101 - Cash Application	1-15 Days
101 - Cash Application	1-15 Days
100 - Please Select	16-30 Days
100 - Please Select	1-15 Days
100 - Please Select	16-30 Days
100 - Please Select	16-30 Days

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

Row Labels	1-15 Days	16-30 Days
100 - Please Select	1	3
101 - Cash Application	3	4

In Excel this is pretty straight forward to do.

How to do it in QlikView? 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.

Thanks,

Miguel

[bbi_mba_76]

Hi,

a pivot table with this dimensions:

Full Text Reason Code
Days Bucket

and then an expression that count the occurencies.

[manas_bn · Accepted solution]

Miguel,

You need to create a pivot table with both columns as dimensions and count(Reason) as expression. Just drag the Days Bucket column to the top and you get the chart as shown below... If you get some other data, it adds to the table

By the way, have you had a look at the Interval match function? - You could define the ranges based on the from and to dates (in case you have it in your data)

Ex: http://community.qlik.com/message/123387#123387