Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

bgarland
Contributor III

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

Re: Query Question

See attached qvw


talk is cheap, supply exceeds demand
2 Replies

Re: Query Question

See attached qvw


talk is cheap, supply exceeds demand
bgarland
Contributor III

Re: Query Question

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

Community Browser