topic Re: Convert tables in QlikView

Convert tables

Fri, 11 Oct 2013 16:02:15 GMT

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

Re: Convert tables

bbi_mba_76 — Fri, 11 Oct 2013 16:08:11 GMT

Hi,

a pivot table with this dimensions:

Full Text Reason Code
Days Bucket

and then an expression that count the occurencies.

Re: Convert tables

manas_bn — Fri, 11 Oct 2013 16:23:39 GMT

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