Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor

What if some dates are not there?

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

SalesManIDTDateYearMonth of TDateActualSales($)
112/22/20182018Dec10
111/23/20182018Nov10
109/20/20182018Sep10
109/20/20182018Sep20
212/20/20182018Dec20
210/20/20182018Oct20
208/20/20182018Aug20
308/10/20182018Aug20
310/24/20182018Oct20

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

Tags (2)
1 Reply
Highlighted
Esteemed Contributor III

Re: What if some dates are not there?