Trend in Straight Table

[#1]

Hello,

I have backed with another question about straight table trend calculation. Now I am using arrow indicator and it works. But the problem is what about objects that they don't have any data in some month?!! How can i avoid this problem. I mean only show the indicators(Up or Down ) for those that have data for all 3 month.

What I have done I have calculated Max(lastMonth) , Max(LastMonth)-1 and Max(LastMonth)-2.  and then I did comparison in two columns. but when there is no data then the conclusion isnot right! For example for E object it shows decrease from last month to moth before.

	SalesAmount 2017-01	SalesAmount 2017-02	SalesAmount 2017-03	Arrow Indicator LastMonth Vs. LastMonth-1	Arrow Indicator LastMonth-1 Vs.LastMonth-2
F	24	155	12
E	24	14
D			34
C	10	40	90
B	60		130
A	35

[ahaahaaha]

Hi Shirin,

Can you just check the fields for missing data? If one of the fields of the expression has the value NULL, just show the value "no data" instead of the result of calculations?

Regards,

Andrey

[Frank_Hartmann]

have a look at the attached sample.

hope this helps

[#4]

Hello Frank,

Have you attached here or in my other post?

BR,
Shirin

[Frank_Hartmann]

If you watch this thread through your inbox you wont see the attached files:

Look here:

Trend in Straight Table

[#6]

Thanks Frank. Now I can see. Your script level is a bit too high for me I will try to find an easier way.

Anyhw Thanks for your time.

[Frank_Hartmann]

attached sample might be easier to understand but anyway,

you will need to explain the difficulties you are facing otherwise it will be hard to assist

hope this helps

[#8]

Thank you Frank. Actually I used your previouse attachment and made it in my simple way. Those if Column(1)<>0 ... helped and my problem solved. Thanks for your help.

[Frank_Hartmann]

Then please close the threads by marking the correct an helpful answers. This will be helpful for future visitors of this thread to see what was helpful and correct!

Qlik Community Tip: Marking Replies as Correct or Helpful

Note: You will need to go to the original thread. Through Inbox you will not have the option to mark the correct or helpful answers!