topic Re: question about average in QlikView

question about average

Anonymous — Mon, 18 Jun 2012 19:10:28 GMT

Hi Qlikgurus,

i need to work out an expression but it's showing me null

my data is like this

col1- 24%

col2- 17%

col3- 19%

col4- 20%

AVG - 20%

this is how it looks in the straight table and now i want that avg vaule i.e 20 in my case as 3rd column like this

col1- 24% 20

col2- 17% 20

col3- 19% 20

col4- 20% 20

Total - 20% 20

for vaules 24, 17, 19 20 i'm using some set anaysis expression

how do write expression for getting that avg 20 vaules ..can somebody help me

Thanks

Have a great day

Re: question about average

chematos — Mon, 18 Jun 2012 19:50:17 GMT

I don´t know your filed names so I´m going to think up a field that contains your percentages, so you could use something like this:

sum(total Percentage) / 4

Re: question about average

Anonymous — Mon, 18 Jun 2012 19:55:08 GMT

thanks jose for your reply..........

but in my case the fileds i'm using has different no of field vaues

in other words col1 to colN

in that case how to deal with this

do u want me to attach my sampe data

Re: question about average

chematos — Mon, 18 Jun 2012 20:01:49 GMT

that would be helpfull, thanks

Re: question about average

Anonymous — Mon, 18 Jun 2012 20:11:30 GMT

here my sample data

Re: question about average

Anonymous — Mon, 18 Jun 2012 21:28:42 GMT

any suggestion pls

Re: question about average

swuehl — Mon, 18 Jun 2012 21:52:26 GMT

Are you looking for the expression total?

=(COUNT(total {<QUADRANT_WO_VF={'Bottom Left'}>}ADWEEK))/(COUNT(total (ADWEEK))-COUNT(total {<QUADRANT_WO_VF={""}>}ADWEEK))

Re: question about average

Mon, 18 Jun 2012 21:52:44 GMT

I think the word "total" is your friend.

count(total FIELDNAME) makes sure that not the count per dimension is calculated but the total count...

Find the attached sample to see how I calculated the 31% column.

Hope it helps.

ps: apparently swuel was a bit quicker than me 🙂

Re: question about average

Anonymous — Tue, 19 Jun 2012 13:37:38 GMT

thanks you guys seems like it's preety simple ..but i wasted 3 days on this this

really apperciate your help thanks

have a great day