Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Trend in Straight Table

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

F2415512
E2414
D34
C104090
B60130
A35
8 Replies
ahaahaaha
Partner - Master
Partner - Master

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

have a look at the attached sample.

hope this helps

Not applicable
Author

Hello Frank,

Have you attached here or in my other post?

BR,
Shirin

Frank_Hartmann
Master II
Master II

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

Look here:

Trend in Straight Table

Not applicable
Author

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

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

Not applicable
Author

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

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!