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: 
philgood34
Creator II
Creator 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
Creator II
Creator II
Author

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