topic Re: Problem In Expression Defination regarding Avg() function in QlikView

Problem In Expression Defination regarding Avg() function

Mon, 01 Sep 2014 07:00:29 GMT

Hi Everyone,

I have one problem regarding average function in Expression Defination. when i am defining if(SALARY > 16500,SALARY,0) then it is giving the expected output.but when i am using if(SALARY > Avg(Salary),SALARY,0) then nothing is apearing in the output ....

I am unable to find the solution of this problem so far.....

Can anybody tell me why it is not working ????????

Regards

Sarfaraz

+91 -7620140822

Re: Problem In Expression Defination regarding Avg() function

jagan — Mon, 01 Sep 2014 07:21:05 GMT

Hi,

Try like this

if(SALARY > Avg(TOTAL Salary),SALARY,0)

Regards,

Jagan.

Re: Problem In Expression Defination regarding Avg() function

mdmukramali — Mon, 01 Sep 2014 07:27:31 GMT

Dear Sarfaraz,

Try to store the Avg(SALARY) into a variable.

vAvgSal= Avg(SALARY)

then try the below expression

= if(SALARY > $(vAvgSal) ,SALARY,0)

Thanks,

Mukram

Re: Problem In Expression Defination regarding Avg() function

Mon, 01 Sep 2014 07:53:06 GMT

Thanks a lot Mr.Jagan......Your solution is working as expected.

Can you please explain me about this Avg(Total SALARY)...What actually hapening in this ....so that it will be good for me from knowledge perspective....

Regards

Sarfaraz

Re: Problem In Expression Defination regarding Avg() function

jagan — Mon, 01 Sep 2014 08:04:39 GMT

Hi,

TOTAL ignores all the dimensions in the chart, so you will get the overall average, if you do not use TOTAL then you will get the row wise Average. Hope this helps you.

Please close this thread if you go the solution.

Regards,

Jagan.