Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: Linking Dates problems (Costs and Revenue)

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

Not applicable

Re: Linking Dates problems (Costs and Revenue)

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

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

I agree with Ralph.

Set up a calendar table and join cost and revenue.

Have a look at the example.

Community Browser