Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

micsim123
New Contributor III

Qlik Sense pivot table measure and dimensions in columns

Hi

I have this pivot table with a column dimension: 7_scale_result.

Skærmbillede 2017-10-14 kl. 11.20.07.png

I want to add a column with a measure of average af 7_scale_result. I can make this table, but obviously i only need the total average column and not the average of each grade.

Skærmbillede 2017-10-14 kl. 11.21.41.png

Thanks in advance!

Michael

3 Replies

Re: Qlik Sense pivot table measure and dimensions in columns

Hi Michael, in properties panel (edit mode -> right panel), in the dimensions section yo have a check to 'Show totals'.

This option is shown in the first dimension, so maybe you need to drag 7_scale_result as the first dimension, change the setting, and drag again to second dimension.

micsim123
New Contributor III

Re: Qlik Sense pivot table measure and dimensions in columns

Hi Ruben

I tried, but can't get it to work.

In this table, I want to exclude the columns in red,so i only get the average.

Results_and_Grades_-_Grades_Pivot_table___Sheets_-_Qlik_Sense.png

My settings are:

Skærmbillede 2017-10-14 kl. 14.57.38.png

Best regards

Michael

Re: Qlik Sense pivot table measure and dimensions in columns

Hi Michael, having a dimension below the measures causes to repeat all dimension values for each expression.

One way to avoid this is simulating the measures using another dimension. And using SecondaryDimensionality() you can select wich columns have to show.

I attach an example, maybe there is an easier way to do this.