Synchronising daily data with monthly data in QlikView

Fri, 12 Sep 2014 11:07:32 GMT

I have two tables in my QlikView model.

One table has daily sales data and the other has monthly spend data.

In my QlikView application, I have a table which shows the sum of sales for a department. When a user selects a date from the calendar, they will see the MTD sales for that department.

The spend figure for a department is also required to be used in the same table. So when a user selects a date (let's say 15/08/2014) the user should see the MTD sales for all departments for that selected date but also see the monthly spend of the departments for the month of August.

When I try to do the sum of the Spend value in the same table and select a date, I get the correct sales value but I get a 0 for the spend value. When a user selects a month from the calendar (August in this case) then the Sales value is correct and the Spend value is correct. The main required functionality of this app is to have the user select a date rather than a month as values are analysed based on daily information.

Is the above scenario possible?

Re: Synchronising daily data with monthly data in QlikView

miikkaqlick — Fri, 12 Sep 2014 11:16:35 GMT

Hi!

This is possible.

There are many ways to do this, but maybe simplest one:

Pseudo-code:

Sales = Sum(Sales)

Costs = Sum( {<Date=, Month = { $(=Month(Date)) } > Cost)

Formula in costs takes away date selection, converts date to month and applies it to costs.

Br,

Miikka

Climber Finland

topic Synchronising daily data with monthly data in QlikView in QlikView

Synchronising daily data with monthly data in QlikView

Re: Synchronising daily data with monthly data in QlikView