Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

Hi,

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

Sample.jpg

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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

9 Replies
rubenmarin

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

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

Not applicable
Author

Hi Ruben,

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

Sample.jpg

rubenmarin

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.

Not applicable
Author

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

IamBack
Champion
Champion

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

Sunil Chauhan
Not applicable
Author

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

Not applicable
Author

Thank you, yes, this is what i want.

IamBack
Champion
Champion

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



Sunil Chauhan
Not applicable
Author

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