topic Comparing sales weekwise in QlikView

Comparing sales weekwise

montubhardwaj — Thu, 24 Feb 2011 07:52:05 GMT

Hi Community,

I have to create a QlikView report which will compare current year and last years of data week wise. I have made significant progress on this but struck at one point.

I actually want to calculate the difference in the sale in each category for this year and last year. I mean I want to have another column under 1or 4 week sales which which will calculate the diff between the sales i.e. (Sale in 2011-Sale in 2010).. But I am not able to have this column added 😞

Output should be something like below:

I have attached the sample report too.Please advise me how to get this done.

Many thanks for your help/advise in advance!

Comparing sales weekwise

deepakk — Thu, 24 Feb 2011 08:23:52 GMT

hi Sharma,

Dont add the Year as dimension. Add three expression as follows.

1) Sum({<Year={$(=Max(Year))}>} Sales ) this will give you the max(Year) . i.e 2011

if the user selects 2010 then 2010.

2)Sum({<Year={$(=Max(Year)-1)}>} Sales ) this will give you the Max(Year)-1 i.e 2010

if the user selects 2010 then t will shows sales of 2009

3) Column(1) - column(2).

I hope this helps

Comparing sales weekwise

montubhardwaj — Thu, 24 Feb 2011 08:34:20 GMT

Hi Deepak.... thx a lot bud.... but will be great if u can do this concept in the attached one ? I know it is too much for but am nt getting it much 😞

Also i think if we do this way, we will get only the difference for "1 week sale". But I want the difference for each column i.e for "1 week sale"., "4 week sale" and so on.

Hope I am not bothering you much 😞

Comparing sales weekwise

montubhardwaj — Thu, 24 Feb 2011 08:54:27 GMT

This is what i want exactly. Please let me kno if it is possible.

Please reffer to the attached(upper post) sample QVW file.

Comparing sales weekwise

deepakk — Thu, 24 Feb 2011 11:27:31 GMT

hi Sharma,

PFA

Comparing sales weekwise

montubhardwaj — Thu, 17 Mar 2011 13:19:08 GMT

Many Thanks