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: 
Anonymous
Not applicable

Sum 2 months in single month

I am creating a pivot table showing FY 2017 Headcount data. Here i want to merge Dec-2016 values (for a certain Headcount type) in Jan 2017, as my pivot table is for 2017. The result should be a table showing 12 months (Jan 2017- Dec 2017) + Dec 2016 values to be added in Jan 2017.. How do i achieve this. I dont want Dec 2016 to be seen in the table.

3 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Prasnna,

with the help of set analysis you can achieve anything.like below:

Sum({<MonthYear = {"Dec 2016"}>}Value)

Thanks

Arvind Patil

sergio0592
Specialist III
Specialist III

Just write as dimension in your chart :

=if(MonthYear='12/2016','01/2017', MonthYear)

vvira1316
Specialist II
Specialist II

If it is handled that way for every December then you can handle it in scripting. May be by creating another dimensional value so you will still have the original dimension if you need to use it for other purposes.