topic Re: LINEST_M function for Month in QlikView

LINEST_M function for Month

rkpatelqlikview — Tue, 05 Jun 2018 18:30:27 GMT

Hi All,

I used this Linest_function for week. Its working properly.

The same function is used for MOnth analysis.

But there is a bug. Can any one please suggest on this?

Am attaching the QVW.

Thanks in advance..

Re: LINEST_M function for Month

sunny_talwar — Tue, 05 Jun 2018 19:16:09 GMT

Try this... when you have Month selected....

=LINEST_M({<[Safety Category] ={'Green'}, Month= {">=$(=MAX(Month)-5)"}>}Aggr(Round(Sum({<[Safety Category] ={'Green'}, Month= {">=$(=MAX(Month)-5)"}>}[Kms Travelled])/sum({<Month= {">=$(=MAX(Month)-5)"}>}[Kms Travelled])*100),Month), Month)

Re: LINEST_M function for Month

rkpatelqlikview — Wed, 06 Jun 2018 08:12:58 GMT

Hi Sunny,

Thanks for your great support. It's correct

Re: LINEST_M function for Month

rkpatelqlikview — Wed, 18 Jul 2018 04:44:46 GMT

Hi Sunny,

There is a small doubt on this. Again

there is 2 conditions:

1) If the values all are '100%' for all the weeks the "Top Green Arrow symbol should be visible.

2) If the values all are '0%' for all the weeks the "Bottom Red Arrow" symbol should be visible.

As per Linest function the symbol is different on above conditions. But these 2 conditions should be satisfied.

Where i can use this 'IF' Condition.?

Re: LINEST_M function for Month

sunny_talwar — Wed, 18 Jul 2018 10:04:21 GMT

I am not sure I follow, may be because the discussion has been 1 month old... do you mind expanding with images as to what is not right?

Re: LINEST_M function for Month

rkpatelqlikview — Wed, 18 Jul 2018 15:24:11 GMT

Thanks for your response Sunny.

Here am attaching the QVW file where the exact scenario.

It's not wrong which you have suggested. There is a two condition to be satisfy in my linest.

Where i need to write the condition?

In Attached QVW the values are '0' then the symbol should be Green Thumbs up symbol.

IF the all values are '100' then the symbol should be Red Thumbs up.

Thanks in Advance.

Re: LINEST_M function for Month

sunny_talwar — Wed, 18 Jul 2018 15:30:37 GMT

I am not 100% sure... but for green thumbs up... layout condition =vha=0.... for red thumbs down =vha=100

Re: LINEST_M function for Month

rkpatelqlikview — Wed, 18 Jul 2018 16:25:53 GMT

thanks for your support Sunny.

I will check with if condition in layout

in Red symbol -> IF(vha=100,vha>0,0)

In Green symbol -> IF(vha=0, vha<0,0).

Please suggest if am wrong.. thanks in advance.

Re: LINEST_M function for Month

sunny_talwar — Wed, 18 Jul 2018 16:27:36 GMT

I am not sure I follow your question to be able to answer if what you have is correct or not... may be try it out and see if it works or not

Re: LINEST_M function for Month

rkpatelqlikview — Wed, 18 Jul 2018 16:52:09 GMT

Sure Sunny. thank you

Re: LINEST_M function for Month

rkpatelqlikview — Fri, 20 Jul 2018 04:59:04 GMT

Dear Sunny,

Thanks for your response. This is the sample Excel file which is need to implement in Qlikview for Linest.

Re: LINEST_M function for Month

rkpatelqlikview — Fri, 20 Jul 2018 06:00:42 GMT

Dear Sunny,

This has been done. But i can't see the image with that link. May i know how to fetch the symbols in text object?

Re: LINEST_M function for Month

sunny_talwar — Fri, 20 Jul 2018 12:01:56 GMT

Which symbol are we talking about? Can you please explain using images or examples?