topic Re: How to limit +2sd more than 100% in chart in QlikView

How to limit +2sd more than 100% in chart

Wed, 03 Dec 2014 07:58:29 GMT

Hi,

Attached is an image of the +2sd line that I have done up.

In this chart, the +2sd is more than 100%. May I know how to limit the chart if it goes more than 100%.

I wish to set the limit at 100%

my calculation = Mean + (2 * SD)

Because the 2*SD is higher than the mean, this is why it goes out of 100%.

Would need advise on this.

Thanks

Chun Wey

Re: How to limit +2sd more than 100% in chart

rubenmarin — Wed, 03 Dec 2014 08:22:01 GMT

Hi Chun, is there if the max possible value is 100, you can use:

RangeMin(Mean + (2 * SD), 1)

Re: How to limit +2sd more than 100% in chart

Wed, 03 Dec 2014 08:26:49 GMT

Hi Ruben,

it give me all 100% including other dimensions. Or should i include set analysis as well ?

Re: How to limit +2sd more than 100% in chart

rubenmarin — Wed, 03 Dec 2014 08:43:18 GMT

Hi, it's supposing to keep only the min value of your expression or 100%, not sure of what value is returning "Mean + (2 * SD)" if it's higher than 1.

Also probably needs to filter to show only values where not isnull(Mean + (2 * SD)) or change for a simplier:

If(Mean + (2 * SD)>1, 1, Mean + (2 * SD))

Again, "1" is meaning 100%, if your espression return 100 for a 100% it should be If(Mean + (2 * SD)>100, 100, Mean + (2 * SD))

Hope this helps, if not, with a sample I can give more help.

Re: Re: How to limit +2sd more than 100% in chart

Wed, 03 Dec 2014 09:01:44 GMT

Hi Ruben,

Thanks for ur help!

Attached is the qvw.

Please go to Monthly Performance Tab -> Question Type ->Select FC.

You will see the issue,

Thanks again.

Chun Wey

Re: How to limit +2sd more than 100% in chart

SunilChauhan — Wed, 03 Dec 2014 09:08:29 GMT

goto chart properties -> axis-> static max->

here type max(expression written in +2sd)*1.2

this will set max for you chart suppose is value then it will set to 120 as max

hope this helps

Re: Re: Re: How to limit +2sd more than 100% in chart

Wed, 03 Dec 2014 09:10:36 GMT

Hi Chunwey,

so are you just wanting any of the individual points which go above 100% to be forced to 100% instead? Something like this?

hope that helps

Joe

Re: How to limit +2sd more than 100% in chart

Wed, 03 Dec 2014 09:16:46 GMT

Thank you, yes, this is what i want.

Re: How to limit +2sd more than 100% in chart

SunilChauhan — Wed, 03 Dec 2014 09:19:52 GMT

would you think 100% will be static when 2s value become 101 then it will give wrong projection.

Re: How to limit +2sd more than 100% in chart

Wed, 03 Dec 2014 09:27:19 GMT

Hi chauhans85,

Yes, if it is more than 100%, it is definitely wrong projection.

This is why I am limiting to 100%.

Thanks

Chun wey