Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

philgood34
Contributor II

PIVOT TAB AGGR %

Hi,

I think i have a very classic issue with PIVOT TABLE, but i did'nt found solution for the time being ...

I demonstrate with a sample :

i have this PIVOT TABLE calculating cumulative  % MARGIN

first i calculate from absolute value  : it's working

margin_€.png

Now i want to calculate from relative values.


So i have to use Aggr ()/total ...

Here my issue : my expression accumulate the values over the periods (Year & Month)

margin_%.png

i tried also without Dimensionality ()=0

or with SecondaryDimensionality ()=0

No way :-((

An idea ?

Regards

Philippe

1 Reply
philgood34
Contributor II

Re: PIVOT TAB AGGR %

Hi

I found the solution

It was not a issue concerning PIVOT TAB

My expression did’nt need AGGR !

Here is the good expression for my issue :margin_GOOD.png

Sorry for that

on the other hand do you know how to decrease the width of the columns in a pivot table? is it possible ?

Regards

Philippe

Community Browser