Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Linking Dates problems (Costs and Revenue)

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???

3 Replies
rbecher
MVP
MVP

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

Astrato.io Head of R&D
Not applicable
Author

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.

Not applicable
Author

I agree with Ralph.

Set up a calendar table and join cost and revenue.

Have a look at the example.