topic Re: Linking Dates problems (Costs and Revenue) in QlikView

Linking Dates problems (Costs and Revenue)

Tue, 24 Sep 2013 11:40:14 GMT

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

Re: Linking Dates problems (Costs and Revenue)

rbecher — Tue, 24 Sep 2013 13:50:51 GMT

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

Re: Linking Dates problems (Costs and Revenue)

Tue, 24 Sep 2013 14:46:22 GMT

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.

Re: Re: Linking Dates problems (Costs and Revenue)

Tue, 24 Sep 2013 15:12:24 GMT

I agree with Ralph.

Set up a calendar table and join cost and revenue.

Have a look at the example.