Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Pivot Table Expression - % of Sales

I have created a Pivot Table of Sales and I am trying to convert Sales values to a % of Sales for that specific column.   See attached document.

3 Replies
MVP
MVP

Re: Pivot Table Expression - % of Sales

Try something like this as expression

=If( SICCodeDesc = 'EF',

     Sum(Amount), // replace Sum(Amount) here and below with your current measure

   Sum(Amount) / Sum(TOTAL<SICCodeDesc> Amount)

)

Not applicable

Re: Pivot Table Expression - % of Sales

Hi Ryan,

swuehl expression is correct,but i just add the Num format to the expression

IF(SICCodeDesc='EF',Num(Sum(Sales),'$#,##0'),

    Num(Sum(Sales)/Sum(Total<SICCodeDesc> Sales),'#,##0%'))

And leave the Number format in sense to Auto

Not applicable

Re: Pivot Table Expression - % of Sales

It worked.  Thank you for the help