What if some dates are not there?

rammarthi — Thu, 08 Nov 2018 16:40:44 GMT

I have two tables one fact table with SalesManID,TDate and ActualSales($). Now there are some sales man who dont have some months of data for their IDs

SalesManID	TDate	Year	Month of TDate	ActualSales($)
1	12/22/2018	2018	Dec	10
1	11/23/2018	2018	Nov	10
1	09/20/2018	2018	Sep	10
1	09/20/2018	2018	Sep	20
2	12/20/2018	2018	Dec	20
2	10/20/2018	2018	Oct	20
2	08/20/2018	2018	Aug	20
3	08/10/2018	2018	Aug	20
3	10/24/2018	2018	Oct	20

Plotting the above on Line Chart against ActualSales as Metric on Y Axis and TDate on X Axis primary dimension/ first dimension and SalesManID as Second Dimension. Now for each of the IDs I want to see all the Months. Say for For ID 1 I want to See Sep Oct Nov and Dec. For ID 2 I want to see Aug Sep Oct Nov Dec etc. but ryt now for ID 1 I am only seeing Sep, Nov and Dec as data has only those values. I expect to see 0 values for Aug, and Oct for ID 1.

Thanks in advance

Ram Marthi

Re: What if some dates are not there?

vishsaggi — Thu, 08 Nov 2018 16:58:13 GMT

Check here?

Generating Missing Data In QlikView

topic What if some dates are not there? in QlikView

What if some dates are not there?

Re: What if some dates are not there?