Solved: % calculation in a straight table - Qlik Community

Anonymous · ‎2014-09-02

Hi, I am trying to calculate the % breakout per the yellow highlight in the screenshot below in a straight table. Can anyone help please?

Thanks.

JonnyPoole · ‎2014-09-02

it should, just change the field after the TOTAL clause in the denominator to the field that represents the subtotal.

change:

=sum(if(Dataset='Recent',Revenue))/ sum( TOTAL <Segment_Classification> if(Dataset='Recent',Revenue) )

to:

=sum(if(Dataset='Recent',Revenue))/ sum( TOTAL <BU> if(Dataset='Recent',Revenue) )

View solution in original post

JonnyPoole · ‎2014-09-02

try hitting the 'relative' checkbox on the expressions tab of the chart properties. it will render the values as percent of total

Anonymous · ‎2014-09-02

Sorry, this is what i am trying to achieve.

Thanks

Anonymous · ‎2014-09-02

Hi, thanks. Relative works but i am trying to get to achieve this. The % rates are off if I use relative.

Thanks again.

JonnyPoole · ‎2014-09-02

no problem. to get a % subtotal you would want the following expression. Then format to a % on the number tab.

sum( [Total Revenue]) / sum( total <Group> [Total Revenue])

Anonymous · ‎2014-09-02

I am getting nulls...

JonnyPoole · ‎2014-09-02

Can you open this example ?

Anonymous · ‎2014-09-02

I am using personal edition....

JonnyPoole · ‎2014-09-02

If you have PE , then please upload your QVW or a sample QVW and i will tweak the expressions. I will copy/paste the expressions and any other tweaks to get it to work so that you can manually apply to your own QVW. sound good ?

Anonymous · ‎2014-09-02

Hi I am having a hard time attaching the qvw, might have been a little big. I thought it was uploaded but I am not able to see it. Can you see it?

Thanks,

% calculation in a straight table

Related Topics