Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Current Month&Previous Month Calculation Only on one selection

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

1 Reply
Not applicable
Author

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)