Solved: Re: percentage in straight table - Qlik Community

arulsettu · ‎2014-05-16

hi

i am having three years sale in straight table

like 2003 2004 2005

now i need show the percentage ho can i do that?

alexandros17 · ‎2014-05-16

Write this expression in the column %:

sum({<Year={$(=max(Year))}>}Cheque)

/

sum({<Year={$(=max(Year)-1)}>}Cheque)

alexandros17 · ‎2014-05-16

Column(2)/Column(3) gives you the percentage of 2005 on 2004, go in Numbers tab and set this new column to decimal and check show in percentage box

arulsettu · ‎2014-05-16

i think not working. any expression for the percentage?

nizamsha · ‎2014-05-16

num((currentyr-lastyr)/currentyr,'#,##.00%')

arulsettu · ‎2014-05-16

it showing 10% for every row

alexandros17 · ‎2014-05-16

Not integer, set to decimal with 2 deciìmal digits,

let me know

nizamsha · ‎2014-05-16

In number format fixed to 2 decimal and check show in percentage

nizamsha · ‎2014-05-16

not integer fixed to 2 decimal and check the show percentage option

arulsettu · ‎2014-05-16

are we calculating percentage for two years?

arulsettu · ‎2014-05-16

looking for result like this