topic Re: How to calculate % in Pivot table in QlikView

How to calculate % in Pivot table

Anonymous — Mon, 20 Feb 2017 16:19:01 GMT

Hi All,

I want to calculate % of Total expression for the below scenariao.

For Breakfast-- expected o/p is 2/8,2/8,4/8 and for dinner---- 75/102, 14/102,2/102 ,12/102 and for lunch 7/384,175/384......etc.

Can you help me to find logic for %Total.Please find the attached qvw.

Re: How to calculate % in Pivot table

aarkay29 — Mon, 20 Feb 2017 16:38:38 GMT

check this

Re: How to calculate % in Pivot table

Anonymous — Mon, 20 Feb 2017 17:07:11 GMT

Hi Kay,

If my TS Logic is = count({<ShortText={'Nursing Unit Reporting Group'}>}DISTINCT (SurvID)).

what will be %TS ? Expected o/p is 261/9245,105/9245....etc

Re: How to calculate % in Pivot table

aarkay29 — Mon, 20 Feb 2017 17:15:05 GMT

Did you try this:

count({<ShortText={'Nursing Unit Reporting Group'}>}DISTINCT (SurvID))/(count(Total<ShortText>{<ShortText={'Nursing Unit Reporting Group'}>}DISTINCT (SurvID)))

Re: How to calculate % in Pivot table

Anonymous — Mon, 20 Feb 2017 18:42:23 GMT

Thanks Kay,

it is working fine by replacing shorttext with Unit