Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

Table expression ignoring my calculated dimension

Hello, 

I have created a pivot table.

I would like to have in each column (1,2,3,4,5) the total sum of the values of the line.

It's not easy to explain, but I have create an app with comment which shoulg helps a lot.

Thank you for your help 2019-01-28_16h52_59.png

Labels (2)
1 Solution

Accepted Solutions

Re: Table expression ignoring my calculated dimension

Try this

=Aggr(NODISTINCT Sum( NB_DEPARTS_ENGINS * FL_SEUIL), SECTEUR)
2 Replies

Re: Table expression ignoring my calculated dimension

Try this

=Aggr(NODISTINCT Sum( NB_DEPARTS_ENGINS * FL_SEUIL), SECTEUR)
Partner
Partner

Re: Table expression ignoring my calculated dimension

Thank you so much for this fast and efficient solution !

Great 🙂