Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
have you tried including it in your match statement?
Pick(Match($(Var),1,2,3),fabs(GROUP_CLASS),fabs(BRAND_),fabs(SEGMENT_)))
have you tried including it in your match statement?
Pick(Match($(Var),1,2,3),fabs(GROUP_CLASS),fabs(BRAND_),fabs(SEGMENT_)))
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)
)
Hi Andy
Thank you very much it work fine now.
Paul
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
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
Can you post more detail on your question.