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: 
Anonymous
Not applicable

Query Question

I have a SQL Server table that contains sales data by fiscal week number but not all weeks have sales. However, I need a chart that displays all weeks. How can I write my script so that it will load the data rows I do have and create rows for the data I'm missing?

QueryData.jpg

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached qvw


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

See attached qvw


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Thank you Gysbert. That gives me the method I can use as a basis for my larger, more complexe query.