Discussion board where members can get started with QlikView.
Hope you all doing all. Currently I'm facing some challenges in my current project regarding missing time data generation.
I've created a dummy data set to describe the issue. It would be great if anyone can provide a workable solution for the issue. The .qvw and dummy data file is available as attachment.
I want to show the trend of "No of Orders" placed for a particular Product in a Year. But the trend is showing data points for only those months when some data is present.
Below is the snap of current output and expected output-
Note: In real I'm dealing with 2 million records. So need to keep in mind the reload time and performance of the final application.
Thanks in advance. Cheers.
Try to enable these options for Month and check
1) Show All values (Month Dim)
2) Suppress when value is null (Month Dim)
Thanks Anil for your reply. But its not giving exact output. Below is the snap of output after applying your input-
PFA the updated file , Pls check and revert back incase any issue.