topic Re: Standard deviation lines are not on line in QlikView

Standard deviation lines are not on line

deepakqlikview_123 — Tue, 29 Sep 2015 06:44:47 GMT

Hi All,

PFA

The +1 and -1 stdev lines say they are 65% and 60% respectively,

yet they don't show up on the chart on those lines.

Please suggest

Thanks

nagarjuna_kotha — Tue, 29 Sep 2015 06:54:39 GMT

Hi Deepak,

In the expressions remove TOTAL Function and See the result and let me know if you are reaching your requirement or not ?

This may help you

nagarjuna_kotha — Tue, 29 Sep 2015 06:55:53 GMT

In both expressions +1 and -1 stdev remove TOTAl Function.

Regards,

Naga

nagarjuna_kotha — Tue, 29 Sep 2015 07:01:44 GMT

Try this :

For:

+1: Avg({1<INDICATOR_NAME={'+1_Standard Deviation of SA Occupancy'},COUNTRY={'United States'}>}INDICATOR_VALUE)/100

-1: Avg({1<INDICATOR_NAME={'-1_Standard Deviation of SA Occupancy'},COUNTRY={'United States'}>}INDICATOR_VALUE)/100

tresB — Tue, 29 Sep 2015 07:02:19 GMT

If you change the number format to display more decimal points, you will see these 65 and 60 are actuall 64.63.. and 59.55.. That answer your query.