Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Use of dimensionality in a pivot table

Hi everybody,

I have a big problem making an average column in a pivot table.

As soon as I use a set analysis in the sum column, I loose the last avg column:

Here, the second one seems ok, except it is not the avg but the sum I have in the last column. When I add any set analysis in the sum... I loose the last avg column...

//IF(Dimensionality() = 0, sum(sm.Nombre_Smart)/count(distinct MMM_YY), SUM({$<sm.Métier_SMART={'EPARGNE'}>} sm.Nombre_Smart))

IF(Dimensionality() = 0, sum(sm.Nombre_Smart)/count(distinct MMM_YY), SUM(sm.Nombre_Smart))

Any help welcome,

0 Replies