Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Rangeavg() inside if(), unable to avoid null rows&columns

  • I tried the expression below and the result I got is show in the image(1) below.
               =sum({<Type={'Inventory'}>} Units)

Note: I'm using QV10

  image(1)

image01.JPG.jpg

  • Thereafter I modified the expression with "rangeavg()" function. But I get additional null rows&columns (highlighted in the image below)
  • Also I tried suppress null values, but still I'm getting the same result.

=if(sum({<Type={'Inventory'}>} Units),
    sum({<Type={'Inventory'}>} Units)/
    rangeavg(before(if(sum({<Type={'SalesOut'}>} Units)>=0,sum({<Type={'SalesOut'}>} Units)),0,8))
    )

image02.JPG.jpg

Could anyone please help me to solve this problem?

Thanks in advance

Message was edited by: gunenthiran b

4 Replies
Not applicable

Re: Rangeavg() inside if(), unable to avoid null rows&columns

try suppress missing values

With Regards

Harshita Gaur

Not applicable

Re: Rangeavg() inside if(), unable to avoid null rows&columns

Thank you for your reply.

But i tried suppress missing/null values also not working.

Not applicable

Re: Rangeavg() inside if(), unable to avoid null rows&columns

hi,

can you attach your QVW? and your data sheet?

With regards

Harshita gaur

Not applicable

Re: Rangeavg() inside if(), unable to avoid null rows&columns

Hi Harshita gaur,
I attached my qvw and data sheet in the question.
please find the attachment and please note that we are using QV10.
Thanks

Community Browser