topic Re: Re: percentage in straight table in QlikView

percentage in straight table

arulsettu — Fri, 16 May 2014 06:16:20 GMT

i am having three years sale in straight table

like 2003 2004 2005

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

Re: percentage in straight table

alexandros17 — Fri, 16 May 2014 06:20:14 GMT

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

Re: percentage in straight table

arulsettu — Fri, 16 May 2014 06:24:03 GMT

i think not working. any expression for the percentage?

Re: percentage in straight table

nizamsha — Fri, 16 May 2014 06:27:12 GMT

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

Re: percentage in straight table

arulsettu — Fri, 16 May 2014 06:32:38 GMT

it showing 10% for every row

Re: percentage in straight table

alexandros17 — Fri, 16 May 2014 06:36:10 GMT

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

let me know

Re: percentage in straight table

nizamsha — Fri, 16 May 2014 06:40:16 GMT

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

Re: percentage in straight table

nizamsha — Fri, 16 May 2014 06:41:10 GMT

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

Re: percentage in straight table

arulsettu — Fri, 16 May 2014 06:41:35 GMT

are we calculating percentage for two years?

Re: percentage in straight table

arulsettu — Fri, 16 May 2014 06:44:02 GMT

looking for result like this

Re: percentage in straight table

nizamsha — Fri, 16 May 2014 06:44:51 GMT

can u provide ur sample qvw so others can do if for u

Re: percentage in straight table

arulsettu — Fri, 16 May 2014 06:50:00 GMT

here is the app

Re: Re: percentage in straight table

alexandros17 — Fri, 16 May 2014 06:53:36 GMT

... the example

Re: percentage in straight table

arulsettu — Fri, 16 May 2014 06:57:39 GMT

hi Alexandros17

using personal edition so cant open sorry for the inconvenience

Re: percentage in straight table

alexandros17 — Fri, 16 May 2014 06:59:41 GMT

Write this expression in the column %:

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

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

Re: Re: percentage in straight table

nizamsha — Fri, 16 May 2014 07:01:54 GMT

PFA

Re: Re: percentage in straight table

nizamsha — Fri, 16 May 2014 07:05:23 GMT

=(sum({$<Year={"$(=Max(Year))"}>}Cheque)-

sum({$<Year={"$(=Max(Year)-1)"}>}Cheque))/

sum({$<Year={"$(=Max(Year))"}>}Cheque)

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

Re: percentage in straight table

arulsettu — Fri, 16 May 2014 07:05:54 GMT

thanks all