Discussion Board for collaboration on QlikView Scripting.
Here is the file.
Go to Solution.
You have to aggragate per week first. Try this:
[Fiscal Week Ending] ,
sum([Sales Out $]) as Sales
from US.xls (biff, embedded labels, table is "Sheet 1$") group by [Fiscal Week Ending];
drop table temp1;
Thanks Gysbert. It Works.
Working, was not concentrating on the repitition of data, my mistake.