topic Current vs Previous Sales by Week Number in QlikView

Current vs Previous Sales by Week Number

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone, I am battling with an issue that might seem fairly simple to you but quite a bit tricky to me as a beginner.

So I have 2 excel files that I have loaded into my document. One file gives information about sales amounts, cancel amounts, products etc. The second file has all the dates I need for my calendar and both these 2 files join on a key.

The issue here is that my calendar/Dates file has a column named 'Week Num' and the values of this column start from 10 to 20.

This column is not based on any date, it is just numbers. What I need is to be able to sum the sales amount, cancelled sales per product for current 'Week Num' and Previous 'Week Num' like the snapshot below:

I would really appreciate any help on this, Thank you.

Re: Current vs Previous Sales by Week Number

pradosh_thakur — Mon, 16 Oct 2017 11:00:14 GMT

you need to provide some sample so that we can help you getting to to the result you provided.

regards

Pradosh

Re: Current vs Previous Sales by Week Number

Anonymous — Mon, 16 Oct 2017 11:15:09 GMT

Hi Pradosh, thanks for your response. Please refer to the discussion on this link >> measure for the previous dimension value‌.

I would like to achieve something similar to that except that I do not want to see another column that shows the increase from previous week. I want to be able see and compare the actual totals of the previous and current week sales (Please check out the link above)

Re: Current vs Previous Sales by Week Number

padmanabhan_ram — Mon, 16 Oct 2017 11:15:43 GMT

Hi Sello,

try to use this expression to get previous sales amount.

rangesum(above(sum( [Current Week Sales Amount]),1))

br,

Padmanabhan

Re: Current vs Previous Sales by Week Number

Anonymous — Mon, 16 Oct 2017 13:22:07 GMT

Hi Padmanabhan, thanks for this response. it seems like a solution I am looking for. May you please show me how an expression for current sales amount would then look like?

Re: Current vs Previous Sales by Week Number

padmanabhan_ram — Mon, 16 Oct 2017 15:03:17 GMT

Hi Sello,

check the attache qvw.

Br,

Padmanabhan

Re: Current vs Previous Sales by Week Number

pradosh_thakur — Mon, 16 Oct 2017 16:16:22 GMT

Hi sello

i understood your question but we need some data to work with. You can prepare some sample data in excel which should be similar to your data model and post it here so we can work on that and help you easily with your requirement.

Re: Current vs Previous Sales by Week Number

padmanabhan_ram — Tue, 17 Oct 2017 08:32:20 GMT

Hi Sello,

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Br,

Padmanabhan