Linking Dates problems (Costs and Revenue)

[#1]

So, I have a database with Costs, and other with Revenue. I want to show both together in a graph, Xaxis is date. Problem is, sometimes I have blank fields for Revenue, some other blank fields for Costs, and some for both, Revenue and Costs. Qlikview reads and excludes those blanks, I tried different things (concatenating, creating a date field), I want all dates to appear, show days that we had no revenue, but costs, others with only revenues, and so. How do I do that???

[rbecher]

Hi Julio,

I guess best solution would be to have costs and revenues per date in on table (maybe aggregated). Maybe you can just use a join here.

- Ralf

[#3]

Hey Ralf, I tryed sometimes join table, but it has not worked correctly, I'll try some more times here, and in case it doesn't work ok, i'll attach here my problem.

[#4]

I agree with Ralph.

Set up a calendar table and join cost and revenue.

Have a look at the example.