topic Re: Trend in Straight Table in QlikView

Trend in Straight Table

Wed, 25 Nov 2020 16:16:04 GMT

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
F	24	155	12
E	24	14
D			34
C	10	40	90
B	60		130
A	35

Re: Trend in Straight Table

ahaahaaha — Thu, 04 May 2017 07:54:41 GMT

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

Re: Trend in Straight Table

Frank_Hartmann — Thu, 04 May 2017 08:14:55 GMT

have a look at the attached sample.

hope this helps

Re: Trend in Straight Table

Thu, 04 May 2017 08:24:22 GMT

Hello Frank,

Have you attached here or in my other post?

BR,
Shirin

Re: Trend in Straight Table

Frank_Hartmann — Thu, 04 May 2017 08:26:05 GMT

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

Look here:

Trend in Straight Table

Re: Trend in Straight Table

Thu, 04 May 2017 12:15:36 GMT

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.

Re: Trend in Straight Table

Frank_Hartmann — Thu, 04 May 2017 12:24:20 GMT

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

Re: Trend in Straight Table

Thu, 04 May 2017 13:49:27 GMT

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.

Re: Trend in Straight Table

Frank_Hartmann — Thu, 04 May 2017 13:57:17 GMT

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!