Sorry to say but your question is a bit confusing.
First you are saying the data is coming from a SQL database, second you are saying you wanted to prepare an excel file and then you are saying you wanted to format Excel to get correct output in QlikView????
Please could you clearly explain what you wanted to achieve?
I'm sorry. To clarify myself:
We have the bar chart with the duration in hours of work for the customers for each week. In a List box we have the diffrent customers. When we select a customer from the listbox we see the hours in a bar chart (see picture).
We want to make a Excel-file (like the Excel-file from Petter, see reply from Petter below) with the budget hours for each customer. We want to see the budget hours show in the bar chart (see picture). Sow when we select another customer in the list box, we want to see the budget hours for that customer.
In your load script you could write this:
// Simulates your Customer data from a database:
Chr( Ord('A') + IterNo() -1 ) AS Customer,
RecNo() AS Week,
Ceil( Rand() * 200) + 50 AS HoursWorked
IterNo() <= 3
(ooxml, embedded labels, table is Sheet1);
Your customer budget data could be formatted like this in your Excel-file:
Yes - with a necessary adjustment in the Load Script it will be possible to organize the Excel-file with columns for each customer.
Week# CustA CustB CustC CustD
1 45 120 100 250
2 47 105 110 240
And then you will have to use a CrossTable Load:
FROM [CustomerBudget.XLSX] (.....);