topic Re: Pivot Grid - Total Value is wrong in QlikView

Pivot Grid - Total Value is wrong

Tue, 16 Aug 2016 14:35:22 GMT

Hi! Look at the Expression "Conten." in the attached image. The "Total" value is wrong.

Expression "Conten." = count({<BGLOGContenedorOBodega={'CONT'}>}DISTINCT BGLOGContenedorNro)

Thanks

vishsaggi — Tue, 16 Aug 2016 16:04:18 GMT

IS it possible to share a sample app to look into please ?

richard_chilvers — Tue, 16 Aug 2016 16:06:18 GMT

Have you checked the Total Mode on the Expressions tab of the chart ?

Gysbert_Wassenaar — Tue, 16 Aug 2016 16:06:40 GMT

The total value is correct, but you want a sum of counts instead of a count at the total level. So, sum the counts:

sum(aggr(count( ...stuff...) , Dim1, Dim2, ... etc)). Replace Dim1, Dim2, ... etc with the dimensions of your pivot table.

Tue, 16 Aug 2016 18:36:38 GMT

Hi! Yes! In the second attachment you can see that is disabled (i don't know why)

Thanks

Tue, 16 Aug 2016 18:37:34 GMT

Ok! The problem is that Dimensions are dynamics. The end user can select/unselect the dimension dynamically.

Thkanks

Anil_Babu_Samineni — Tue, 16 Aug 2016 18:50:58 GMT

Perhaps This?

sunny_talwar — Wed, 17 Aug 2016 00:59:02 GMT

How are they selecting it? Can you share a screenshot of the dimension tab?

Gysbert_Wassenaar — Wed, 17 Aug 2016 05:07:47 GMT

Then use a straight table instead of a pivot table and set the Total Mode of the expression to Sum of rows.

Wed, 17 Aug 2016 12:48:19 GMT

Thanks but i need to use a pivot table.

Now is working. I did it using variables to get the selected dimensions and adding it to the expression that you shared me.

Thanks

Wed, 17 Aug 2016 12:49:15 GMT

Now is working. I did it using variables to get the selected dimensions and adding it to the expression that Gisbert shared me.

Thanks