Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
swuehl
MVP
MVP

Are you looking for the expression total?

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

View solution in original post

8 Replies
chematos
Specialist II
Specialist II

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

Anonymous
Not applicable
Author

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
Specialist II
Specialist II

that would be helpfull, thanks

Anonymous
Not applicable
Author

here my sample data

Anonymous
Not applicable
Author

any suggestion pls

swuehl
MVP
MVP

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
Author

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 🙂

Anonymous
Not applicable
Author

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