topic Re: Percentage split in pivot in QlikView

Percentage split in pivot

pranali_gawde — Wed, 25 Nov 2020 16:16:04 GMT

Hi sir,

I am trying to calculate percentage in pivot but after adding month as column that percentage divide into two months.if i selected only one month then it is cming correct.can u plz help me to resolve this issue.

Below is the snapshot and expression for the same.

This is one month:

Two Month

Expression:

Sum(Aggr(sum(DISTINCT{<Flag={'SJ'},fMonth=,[SEGMENT_CODE]={'1','6'}>}TEU),ECARRIER_NAME,Fcldata))

/Sum(total Aggr(sum(DISTINCT {<Flag={'SJ'},fMonth=,[SEGMENT_CODE]={'1','6'},ECARRIER_NAME={'*'}>} TEU), Fcldata))

Re: Percentage split in pivot

rubenmarin — Sat, 07 Jul 2018 09:47:27 GMT

Hi Pranali, TOTAL is used to ignore dimensions (month dimension is also ignored), if you want to keep some dimensions you can add the fields between <>:

Sum(Aggr(sum(DISTINCT{<Flag={'SJ'},fMonth=,[SEGMENT_CODE]={'1','6'}>}TEU),ECARRIER_NAME,Fcldata))

/Sum(total <Month> Aggr(sum(DISTINCT {<Flag={'SJ'},fMonth=,[SEGMENT_CODE]={'1','6'},ECARRIER_NAME={'*'}>} TEU), Fcldata))

Re: Percentage split in pivot

pranali_gawde — Sat, 07 Jul 2018 14:52:57 GMT

Grate,It's working fine.

Thank you so much sir.