Calculate 1 year when only 1 month is selected

[Anonymous]

Hi Guys,

I would like to ask for your help regarding my problem.

Please let me explain my problem brielfly:

This is my data for 2 years:

2011:

Group	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
A	100	110	120	130	140	150	160	170	180	190	200	210
B	150	160	170	180	190	200	210	220	230	240	250	260
C	200	210	220	230	240	250	260	270	280	290	300	310

2012:

Group	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
A	80	90	100	110	120	130	140	150	160	170	180	190
B	130	140	150	160	170	180	190	200	210	220	230	240
C	180	190	200	210	220	230	240	250	260	270	280	290

Formula:

Sales Ratio = Sum Sales this month divided by Sum Sales of the whole year

(ex. If user selects Aug-2012,then Sum (Sales for Aug 2012) divided by Sum (Sales from Aug 2011 to Aug 2012).

Catch:

User wants only to select Aug 2012 in the listbox. Now the user wants to see the result of Sales Ratio. The answer should be: 0.080213903

Question:

What will my expression look like?

Thanks in advance and godbless!

Gerald

[sujeetsingh]

Hi go for SET ANALYSIS

http://community.qlik.com/thread/79951?tstart=0

link.

[sushil353]

you can create two variables

1. first variable will contain the selected date

2. second variable will contain the date of last year

then compare these two variable in your set analysis.

It is better if you post a sample app...

HTH

Sushil

[Anonymous]

Hi Son of Sardar,

I tried using set analysis but it wont fetch the months that are not selected by the user . Thanks by the way.

[sujeetsingh]

Hi Gerald ,

Its ok! why dont you just give a sample file to me with dummy data.

[Anonymous]

Hi Son of Sardar,

I know its funny but I can't attach my qvw file. How do I do it? sorry about this. I just started in QlikView discussions a few days ago.

Thanks,

Gerald

[sushil353]

hi,

use advanced editor option and there you will get option to upload your sample file

it is right top corner when you write any post

[Anonymous]

Hi Son of Sardar,

I think I found it! Please see attached file.

Thanks,

Gerald

[Anonymous]

Hi Sushil,

Please see attached file. Thanks for the help!

Thanks,

Gerald

[sushil353]

There is no file attached... please check