% of total

[francisvandergr]

IN QlikView you have an option "relative""  in an standard table

Rij          Bedrag     % (Relative)

Row 1    200          20

Row 2    700          70

Row 3    100          10

Is there a formula to get % of Total ?

[shraddha_g]

Sum(Field)/Sum(Total Field)

[francisvandergr]

in use with set analysis this is not working

sum({$<Boekjaar={$(vJaar)}>}Gbkmut_Saldo*-1) /

sum({$<Boekjaar={$(vJaar)}>}total (Gbkmut_Saldo*-1)

[shraddha_g · Accepted solution]

This?

sum({$<Boekjaar={'$(=vJaar)'}>} Gbkmut_Saldo*-1) /

sum(Total {$<Boekjaar={'$(=vJaar)'}>} Gbkmut_Saldo*-1)