Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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???
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
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.
I agree with Ralph.
Set up a calendar table and join cost and revenue.
Have a look at the example.