5 Replies Latest reply: Jun 16, 2017 11:29 AM by Sunny Talwar

# % Of total row

Good morning,

I am new on Qlik Sense and I have this problem; I try to ask coworkers but no one give me a good solution.

I have this pivot table on Qlik Sense and I would like to create another column that show the % of those values for each month.

For example, for January what I want is to create a column that show 71% for "no predeterminado" and 29% for "Predeterminado".

In an excel it is quite simple but here I have no idea.

• ###### Re: % Of total row

Sum(Measure)....

You can create a new one like this

Sum(Measure)/Sum(TOTAL <MonthYear> Measure)

• ###### Re: % Of total row

Good Morning Sunny,

Ty so much for ur answer, but i already try it before and it doesn´t work. because i have 2 dimensions on the pivot table.

do u have another idea? I will apreciate it

Ty so much

• ###### Re: % Of total row

What are you two dimensions? This should work with two dimensions....Would you be able to post an image with the above expression? (Make sure you use the correct field names and the placeholders I have used in the expressions above)

• ###### Re: % Of total row

This are all my mesures and dimensions.

Row : "TIPO COMPRA"

Column: "PresentacionPedido"

=if(year(fhPresentacionPedido) = \$(eMaxAno), fhPresentacionPedido_YYYYMM)Column: "PresentaciónPedido"

and the measure is

Count(distinct

{\$<

>}

if(year(fhCreacionPedido) = \$(eMaxAno) and PeriodoFechaFoto = PeriodofhCreacionPedido,

idVehiculo

)

)

Dont know if u need any thing more, if u need pls let me know.

• ###### Re: % Of total row

Oh you are using a calculated dimension... can you carry out these manipulations in the script (for dimension)?