topic Re: Calculating yearly % in straight table in QlikView

Calculating yearly % in straight table

Wed, 26 Dec 2012 04:31:38 GMT

Hi All,

I am using a straight table showing below fields.

Backend contains data for all the years with its Nvalue and i am calculating Ncount using count(N_value) and achieving% using relative component.

Year NCount NCount% Trend

2011 32 42.06

2011 20 25.64

2012 20 25.64

2012 6 7.69

The query is to calculate % basis yearly contribution not dividing it basis all year counts.

Below example of the desired resultset for your ref.

Year NCount NCount% Trend

2011 32 61.54

2011 20 38.46

2012 20 76.92

2012 6 23.08

Need your assistance on how to achieve the above output.

Thanks in advance.

Anonymous — Wed, 26 Dec 2012 04:40:15 GMT

This should do the trick:

Count(N_value)/Count(Total <Year> N_value)

Wed, 26 Dec 2012 05:50:03 GMT

Thanks a lot, yes it worked well.:)

Thanks again.

er_mohit — Wed, 26 Dec 2012 06:16:50 GMT

hey use this expression hope it helps you

sum(DISTINCT ncount)/sum(TOTAL<year>ncount)

and in number you fixed to 2 and checked on show percent%

might be helpful for you..

see the attached file also....

Wed, 26 Dec 2012 09:25:21 GMT

thanks its woking

er_mohit — Wed, 26 Dec 2012 10:07:50 GMT

you should have to mark it as either correct or helpful answer so that it might be helpful for other developers..