Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

prasannazad
New Contributor III

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
Valued Contributor II

Re: Sum 2 months in single month

Hi Prasnna,

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

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

Thanks

Arvind Patil

sergio0592
Valued Contributor II

Re: Sum 2 months in single month

Just write as dimension in your chart :

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

vvira1316
Valued Contributor II

Re: Sum 2 months in single month

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.

Community Browser