Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

% par colonne et ligne sur une tableau croisé dynamique

Bonjour,

Je souhaiterais obtenir une répartition en pourcentage en fonction de deux dimensions (Mois en colonne et objet en ligne), Le pourcentage que je trouve est le % par ligne du total du tableau et non par rapport au mois .

Et si vous pouviez me dire également comment mettre la ligne des totaux en dessous

Merci à tous

3 Replies
oknotsen
Master III
Master III

Since my French is not that good, I hope I understood you correctly:

Your first expression probably is something like "count(vol)".

Your second expression probably is something like "count(vol) / count(total vol)".

Change the second expression to "count(vol) / count (total < month > vol)".

May you live in interesting times!
Not applicable
Author

Hello, you've got it and it works. In fact it's so easy 🙂


You know how I can place the total line under the dynamic table


Thank you

oknotsen
Master III
Master III

Since this is a pivot table, you will have to go to the "Presentation" tab (sorry, don't know the name in French, it is the 5th), in the top left select the dimension (I am guessing "Objet"), and than make sure "show partial sum" is selected. That is the 2nd checkbox under the list of dimensions.

Edit:

O wait... That is how it works in QlikView. I think you are in Qlik Sense and my local install is not updated to 1.1 yet. I fear I can not help you.

May you live in interesting times!