Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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
Highlighted

Re: Table expression ignoring my calculated dimension

Try this

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

View solution in original post

2 Replies
Highlighted

Re: Table expression ignoring my calculated dimension

Try this

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

View solution in original post

Highlighted
Partner
Partner

Re: Table expression ignoring my calculated dimension

Thank you so much for this fast and efficient solution !

Great 🙂