Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
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)
i tried also without Dimensionality ()=0
or with SecondaryDimensionality ()=0
No way :-((
An idea ?
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 :
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 ?