Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

group data and calculations of a pivot table

With the help of forums,

I Create a Pivot Table with Item and MonthYear as Dimension and Sum(Quantity) as expression And this is the result:

itemMonthyearene 2015feb 2015mar 2015abr 2015may 2015Total
88126 1308700130
91152 1439713620682976
91156 162661541291201006
91158 1322192525175
91159 1942773454256
91230 833464852267
91232 000001

Now, I already have as well as the months I mean, how do I add January and February, February and March, March and April and so on. I need to add two and two and leave the results in a column. Because then I get the standard deviation of the months grouped in pairs.

I need this?

itemMonthyearene 2015feb 2015mar 2015abr 2015may 2015jan+febfeb+marmar+aprStandard
  deviation
88126 1308700311178744
91152 143971362068224023334261
91156 1626615412912022822028334
91158 13221925253541445
91159 19427734546111911131
91230 83346485241799427
91232 000000000

Please help me as I do this?

14 Replies
sinanozdemir
Valued Contributor III

Re: group data and calculations of a pivot table

One way to do is to use Column() function:

So for jan+feb - Column(1) + Column(2)

for feb+mar - Column(2) + Column(3)

for mar+apr - Column(3) + Column(4)

Mind you that I am assuming that ene 2015 is an expression and it is the first expression in your pivot table.

Hope this helps.

Not applicable

Re: group data and calculations of a pivot table

Thanks, but where it is placed to function? as expressions?

sinanozdemir
Valued Contributor III

Re: group data and calculations of a pivot table

You just need to create another expression, please see below:

The below is for jan+feb.

Capture.PNG

Not applicable

Re: group data and calculations of a pivot table

Thank you very much for your help, I appreciate very much your comments,

I have Pivot Table with Item (codigo) and MonthYear as Dimension and Sum(Quantity) as expression And this is the result (dimensions):

pivot table  dimensions.png

After leading the column function, I have this:

pivot table  dimensions 1.png

Please help me again, as I do to disaggregate for months as you shown in the picture

Best regards,

Rodrigo Restrepo

sinanozdemir
Valued Contributor III

Re: group data and calculations of a pivot table

Hi Rodrigo,

Either remove that dimension or hide it by using "Enable Conditional":

Capture.PNG

0 will hide this dimension and 1 will un-hide it.

Hope this helps.

Not applicable

Re: group data and calculations of a pivot table

Hi Sinan Ozdemir,

To remove the dimension column I lose months

pivot table 2.png

How else I can take months in columns without him as dimension, that I have because every month are in one column and the column I need is a month.

Thanks, I appreciate your help, you know a lot and I'm just learning

sinanozdemir
Valued Contributor III

Re: group data and calculations of a pivot table

Maybe use it within an expression like the below and then promote it to the top:

Capture.PNG

Not applicable

Re: group data and calculations of a pivot table

Hi Sinan,

I already did and I have this

untitled.png

I can do more

Digvijay_Singh
Honored Contributor III

Re: group data and calculations of a pivot table

Sinan is suggesting the attached one - 175538.PNG