Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

francisvandergr
Contributor II

% of total

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 ?

1 Solution

Accepted Solutions
shraddha_g
Honored Contributor III

Re: % of total

This?

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

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

3 Replies
shraddha_g
Honored Contributor III

Re: % of total

Sum(Field)/Sum(Total Field)

francisvandergr
Contributor II

Re: % of total

in use with set analysis this is not working

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

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

shraddha_g
Honored Contributor III

Re: % of total

This?

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

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