Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert tables

I have something like this in raw data:


Full Text Reason Code

Days Bucket
101 - Cash Application16-30 Days
101 - Cash Application16-30 Days
101 - Cash Application16-30 Days
101 - Cash Application16-30 Days
101 - Cash Application1-15 Days
101 - Cash Application1-15 Days
101 - Cash Application1-15 Days
100 - Please Select16-30 Days
100 - Please Select1-15 Days
100 - Please Select16-30 Days
100 - Please Select16-30 Days

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

Row Labels1-15 Days16-30 Days
100 - Please Select13
101 - Cash Application34

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

1 Solution

Accepted Solutions
manas_bn
Creator
Creator

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

Capture.PNG.png
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

View solution in original post

2 Replies
bbi_mba_76
Partner - Specialist
Partner - Specialist

Hi,

a pivot table with this dimensions:


Full Text Reason Code
Days Bucket

and then an expression that count the occurencies.

manas_bn
Creator
Creator

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

Capture.PNG.png
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