topic Re: Creating a Cross table in Qlikview in QlikView

Creating a Cross table in Qlikview

Thu, 03 Jul 2014 12:26:58 GMT

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?

Re: Creating a Cross table in Qlikview

nilo_pontes — Thu, 03 Jul 2014 12:43:39 GMT

Hi Henrik,

I guess your answer is a pivot table.

Take a look at the attached file, please.

Regards,

Nilo

Re: Creating a Cross table in Qlikview

MK_QSL — Thu, 03 Jul 2014 12:43:52 GMT

CrossTable(Month, Sales)

LOAD Customer,

Jan,

Feb,

Mar

FROM TABLENAMEandLOCATION

Re: Creating a Cross table in Qlikview

Thu, 03 Jul 2014 13:04:29 GMT

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?

Re: Creating a Cross table in Qlikview

nilo_pontes — Thu, 03 Jul 2014 15:20:33 GMT

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