Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
morenasm
Contributor
Contributor

Using multiple sheets with different Dates...Error

Hi Guys

I hope someone can help me. 

I am having trouble with my data. I have a QVD file that i am uploading with sales data and then i have an Excell file im uploading for all the Orders placed. Now both these files have their own relevant dates. I cant seem to get them working. It shows the dates when i build the report but when i select week or month or any time period at adss all the 'QTY Sold' Togther.

[Calendar]:
LOAD Distinct
Year([Cal Date]) as [Year],
Num(Month([Cal Date]),'00') as [Month],
Year([Cal Date]) * 100 + Month([Cal Date]) as [Num Period],
Dual(Monthname([Cal Date]),Year([Cal Date]) * 100 + Month([Cal Date])) as [Period],
MonthName(Date([Cal Date],'DD/MM/YYYY')) as [Year Month];
LOAD
$(vCalStartDate) + IterNo() - 1 as [Cal Date]
AutoGenerate (1)
WHILE $(vCalStartDate) + IterNo() - 1 < $(vCalEndDate);

1 Reply
Lisa_P
Employee
Employee

What does your data model look like ?