topic Re: Condition for picture objects in QlikView

Condition for picture objects

Wed, 22 Jul 2015 10:17:36 GMT

Hi everyone!

I have a condition in objects which stops working if there is no data. Is it possible to fix it?

There are indicators in my QV document which are calculated and represented per month (in dynamics). At the same time for each indicator there is a separate index which is estimated only for the current month:

avg({<MONTH={"$(=max(MONTH))"}>}Field)

For each index there is an arrow identifying is it higher, lower or at the same level as in previous month. Condition for an arrow that represents growth is the following:

len(MONTH) <> 1 and avg({<MONTH={"$(=max(MONTH))"}>}Field)-avg({<MONTH={"$(=max(MONTH,2))"}>}Field)>=1

Problem:

If there is no data in any month, my condition stops working and an arrow is represented despite that (despite there is no data that should be compared).

How condition should be fixed to make it working properly?

Many thanks in advance!

Marina

Re: Condition for picture objects

qlikmsg4u — Wed, 22 Jul 2015 10:20:31 GMT

May be something like, I am not sure but give a try

If(IsNull(avg({<MONTH={"$(=max(MONTH))"}>}Field)),0,avg({<MONTH={"$(=max(MONTH))"}>}Field))

Re: Condition for picture objects

Wed, 22 Jul 2015 10:35:26 GMT

K N,

unfortunately,it is not working. But probably I did something wrong: I need to change this condition for arrows:

len(MONTH) <> 1 and avg({<MONTH={"$(=max(MONTH))"}>}Field)-avg({<MONTH={"$(=max(MONTH,2))"}>}Field)>=1

Using your idea, I've run the following:

If(IsNull(avg({<MONTH={"$(=max(MONTH))"}>}Field)),0,
len(MONTH) <> 1 and avg({<MONTH={"$(=max(MONTH))"}>}Field)-avg({<MONTH={"$(=max(MONTH,2))"}>}Field)>=1)

Did I make it correct?

Re: Condition for picture objects

qlikmsg4u — Wed, 22 Jul 2015 10:52:36 GMT

Marina,

Try this expression and replace the images with your images

=IF(Alt(avg({<MONTH={"$(=max(MONTH))"}>}Field),0)-Alt(avg({<MONTH={"$(=max(MONTH,2))"}>}Field),0)>=1,'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')

Re: Condition for picture objects

qlikviewwizard — Wed, 22 Jul 2015 11:03:36 GMT

Hi Marina_M

Can attach the file with sample data. It will help us for better understanding your issue and provide the right solution. Thank you.