Creating a Cross table in Qlikview

[#1]

Hope someone can help me with this...

I want to create a crosstable in qlikview showing me forecasted sales per month and per customer:

	Jan	Feb	Mar
Customer A	Sales	Sales	Sales
Customer B	Sales	Sales	Sales
Customer C	Sales	Sales	Sales

I have a table looking roughly like this

Load*

Customer

Planned_Invoice_date

Month(Invoice_date) as Month

net_amount

Is there an easy way to get the sales displayed in a crosstable such as the one above?

[nilo_pontes · Accepted solution]

Hi Henrik,

I guess your answer is a pivot table.

Take a look at the attached file, please.

Regards,

Nilo

[MK_QSL]

CrossTable(Month, Sales)

LOAD Customer,

     Jan,

     Feb,

     Mar

FROM TABLENAMEandLOCATION

[#4]

Thanks,

I tried the pivot table before but didn't get the "crosstable expansion" that your exampled showed.

Now I tried it again and by pulling on the sides of the columns I got the crosstable effect and it works the way I want it to.

Is there a way to do get this effect in the chart set-up wizard directly or do I always have to create the chart first and then drag and pull on the columns?

[nilo_pontes]

Henrik, I think this is the only way to do it.