topic Generating Missing dates in Fact table in QlikView

Generating Missing dates in Fact table

joydipp1988 — Wed, 25 Nov 2020 16:16:04 GMT

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-

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

Re: Generating Missing dates in Fact table

Anil_Babu_Samineni — Sat, 04 Nov 2017 16:03:51 GMT

Try to enable these options for Month and check

1) Show All values (Month Dim)

2) Suppress when value is null (Month Dim)

Re: Generating Missing dates in Fact table

joydipp1988 — Sat, 04 Nov 2017 20:22:27 GMT

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

Re: Generating Missing dates in Fact table

dwarikapanigrah — Mon, 06 Nov 2017 12:02:28 GMT

Hi Joydip

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

Regards

Dwarika Panigrahi