topic Re: How to remove negative value in chart ? in App Development

How to remove negative value in chart ?

paulyeo11 — Sat, 29 Aug 2015 10:19:45 GMT

Hi All

I am using QS Variable , my expression is :-

Pick(Match($(Var),1,2,3),GROUP_CLASS,BRAND_,SEGMENT_)

I am aware that "fabs" can help to remove the -ve value , but then i when i try below , it does work :-

fabs(Pick(Match($(Var),1,2,3),GROUP_CLASS,BRAND_,SEGMENT_))

Hope some one can advise me.

Paul

Re: How to remove negative value in chart ?

ogster1974 — Sat, 29 Aug 2015 11:54:44 GMT

have you tried including it in your match statement?

Pick(Match($(Var),1,2,3),fabs(GROUP_CLASS),fabs(BRAND_),fabs(SEGMENT_)))

Re: How to remove negative value in chart ?

maxgro — Sun, 30 Aug 2015 15:48:57 GMT

or rangemax if you want to set the <0 values to 0

Pick(Match($(Var),1,2,3),

rangemax(GROUP_CLASS,0),

rangemax(BRAND_,0),

rangemax(SEGMENT_,0)

)

Re: How to remove negative value in chart ?

paulyeo11 — Tue, 01 Sep 2015 08:55:28 GMT

Hi Andy

Thank you very much it work fine now.

Paul

Re: How to remove negative value in chart ?

ogster1974 — Tue, 01 Sep 2015 09:03:58 GMT

HI Paul

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.

Regards

Andy

Re: How to remove negative value in chart ?

paulyeo11 — Tue, 01 Sep 2015 09:52:43 GMT

Hi Andy

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.

Paul

Re: How to remove negative value in chart ?

ogster1974 — Tue, 01 Sep 2015 10:22:52 GMT

Can you post more detail on your question.

Re: How to remove negative value in chart ?

paulyeo11 — Tue, 01 Sep 2015 10:47:38 GMT

Hi Andy

QS how to reduce the data ?

Above link is my question.

Paul