Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)".
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
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.