I am using QS Variable , my expression is :-
I am aware that "fabs" can help to remove the -ve value , but then i when i try below , it does work :-
Hope some one can advise me.
Solved! Go to Solution.
I'd take Jonathan advice to. As was perfectly valid although its appeared to have disappeared from the thread. You are excluding perfectly valid data from your chart using this method.
With both mine and Massimos approach you should include perhaps a footnote or subtitle message letting the user know what and why you excluded certain data. They have to trust it so any cavets to your charts should be explained.
Or perhaps with my BI hat on I would be wondering why I had a negative in the first place if I didn't want one? Is there a data quality issue in my model or the raw data that needs addressing? Don't be afraid/ hide outliers they are your friend. This is what both Sense and View is good at doing.
Yes i very sorry i just want to delete previous post , because that post consist of sensitive information. and Jonathan post was accidentally deleted.
Yes i do support what Jonathan advise , it is not right to use fabs.
I will add foot note to make remark on chart use fabs.
By the way any idea , i can reduce my qvf file to 10% ? instead of i need to remove the post.