If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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?
Have you tried this (replace the field names I have used with the ones in your example)?:
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])
Try with total (change the fields names)
count(TOTAL <Canale...., Anno...,Mese....> DISTINCT Pratiche...)
If you provide a sample app or spreadsheet with the underlying data, removing anything confidential, I could take another look.