Current Month&Previous Month Calculation Only on one selection

Tue, 03 Aug 2010 18:53:12 GMT

Can Anybody help me to find a solution 4 this problem i am facing here with my current project.

Scenario :

I am having sales amount based on month selection like it i select jan /feb /mar......... i will get correct data for my current selection,but my requirement is that ,i need 2 more selection like previous month ,previous-1month for that i should select only one Month .

that month can be Jan,Feb,Mar.......

if i select month of 'Feb' then i should get data for ,Jan and Dec automatically by selecting only on 'FEB.

if i select month of 'jan' then i should get data for ,Dec and Nov automatically by selecting only on 'JAN

if i select month of 'Jul' then i should get data for ,JUNE and Jul automatically by selecting only on jUL

if i select month of 'Mar' then i should get data for ,feb and jan automatically by selecting only on 'MAR'.

i tried it by using set analysis but i was not able to find the solution .

Please suggest me any method which uses Current selection or Get selected Value.

I need this solution very urgent.............

Thankx in advance......

Plz reply me on.... dushyant@iconresources.com

Dushyant

Current Month&Previous Month Calculation Only on one selection

Tue, 03 Aug 2010 19:53:13 GMT

Do you have variables for your month or are you using fields ? You can try following

Sum({<Month={$(=Only(Month))}>} Sales) for current selected month

Sum({<Month={$(=Only(Month) - 1 )}>} Sales) and

Sum({<Month={$(=Only(Month) - 2 )}>} Sales)

topic Current Month&Previous Month Calculation Only on one selection in QlikView

Current Month&Previous Month Calculation Only on one selection

Current Month&Previous Month Calculation Only on one selection