Qliksense Pivot Table, Row percentage instead of counts

[gio92]

Good Afternoon,

I am tryng to write an expression that allows me to calculate the percentage of each row instead of the distinct count.

Here's an example:

This is my pivot table, I need to write an expression that instead of 1.645 in the first row does this 1645/(1645+1195). Is it possible to do it on Qlik sense? If yes, how?

Thanks!

Gio

[rbartley]

Hi Gio,

Have you tried this (replace the field names I have used with the ones in your example)?: 

Sum(Value)/Aggr(NODISTINCT Sum(Value),Date,Channel)

[gio92]

Yes I just tried your formula and it doesn't work.

Here's what I used:

Count(distinct [PRATICHE.CODICE_OPPORTUNITY_LI])/Aggr(NODISTINCT count(distinct[PRATICHE.CODICE_OPPORTUNITY_LI]),Year([PRATICHE.DATA_SOTTOSCRIZIONE]),Month([PRATICHE.DATA_SOTTOSCRIZIONE]),[PRATICHE.CANALE_ACQ_CONTRATTO])

Thanks anyway

[maxgro]

Try with total  (change the fields names)

count(DISTINCT Pratiche...)

/

count(TOTAL <Canale...., Anno...,Mese....> DISTINCT Pratiche...)

[rbartley]

If you provide a sample app or spreadsheet with the underlying data, removing anything confidential, I could take another look.