How to make the following table in qlikview

[#1]

Hello everyone,

BellowI have a table made with excel were I show the count of failures, their description and on what week they happen.

	Weeks
	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41
Description A	12	26	24	17	25	0	0	0	0	24	13	17	14	15	22
Description B	6	5	10	9	7	0	0	0	0	4	5	7	3	5	12
Description C	7	5	11	9	8	0	0	0	0	2	5	10	5	5	12
Description D	4	14	16	8	9	0	0	0	0	4	9	6	4	6	11
Description E	4	13	19	11	10	0	0	0	0	4	7	5	2	5	10

My question is how can I make the same table on qlikview?

I am not able to have all the columns on the table like I have on excel.

On my data model I have the description of the failures, and the weeks, and I calculate my results.

I have QV personal edition.

Is this possible to do with Qlikview?

Thanks in advance.

Best regards.

Ivo Marques

[simenkg · Accepted solution]

You create a Pivot Table (the top right one in New Chart Object)
Then you put Description and Weeks as dimensions and Sum(Results) as expression //(Or any other expression you use to calculate the result).

Then when the chart is created, click and drag the top of the Week column to the top right of the chart until the blue arrow is horizontal.

The chart should now look like yours.

[Peter_Cammaert]

Use a pivot table.

Add dimensions Description and WeekNr.

Add expression count(somethingthatidentifiesafailure)

Pivot the WeekNr dimension to a horizontal position.

Peter

[#4]

Thank you both that worked like a charm!