Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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
Try with total (change the fields names)
count(DISTINCT Pratiche...)
/
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.