Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
joydipp1988
Creator
Creator

Generating Missing dates in Fact table

Hello All,

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.

Problem:

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-

Current Output.png

Expected Output.png

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.

Joy

3 Replies
Anil_Babu_Samineni

Try to enable these options for Month and check

1) Show All values (Month Dim)

2) Suppress when value is null (Month Dim)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
joydipp1988
Creator
Creator
Author

Thanks Anil for your reply. But its not giving exact output. Below is the snap of output after applying your input-

Output.PNG

dwarikapanigrah
Contributor III
Contributor III

Hi Joydip

PFA the updated file , Pls check and revert back incase any issue.

Regards

Dwarika Panigrahi