Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

srikanthsri1
Valued Contributor

question about average

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

1 Solution

Accepted Solutions
MVP
MVP

Re: question about average

Are you looking for the expression total?

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

8 Replies
chematos
Valued Contributor II

Re: question about average

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

srikanthsri1
Valued Contributor

Re: question about average

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

chematos
Valued Contributor II

Re: question about average

that would be helpfull, thanks

srikanthsri1
Valued Contributor

Re: question about average

here my sample data

srikanthsri1
Valued Contributor

Re: question about average

any suggestion pls

MVP
MVP

Re: question about average

Are you looking for the expression total?

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

Not applicable

Re: question about average

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 :-)

srikanthsri1
Valued Contributor

Re: question about average

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

Community Browser