Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Henrik,
I guess your answer is a pivot table.
Take a look at the attached file, please.
Regards,
Nilo
Hi Henrik,
I guess your answer is a pivot table.
Take a look at the attached file, please.
Regards,
Nilo
CrossTable(Month, Sales)
LOAD Customer,
Jan,
Feb,
Mar
FROM TABLENAMEandLOCATION
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?
Henrik, I think this is the only way to do it.