Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
gio92
Contributor II
Contributor II

Qliksense Pivot Table, Row percentage instead of counts

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?

gio92_0-1636988413531.png

Thanks!

Gio

4 Replies
rbartley
Specialist
Specialist

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)

rbartley_0-1636990901856.png

 

gio92
Contributor II
Contributor II
Author

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
MVP
MVP

Try with total  (change the fields names)

count(DISTINCT Pratiche...)

/

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

rbartley
Specialist
Specialist

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