
Re: Dimension limits with negative values sorted in ascending order in bar chart
Celambarasan Adhimulam Dec 7, 2012 3:19 PM (in response to mchseifert)May be there is a possibility of problems in null values.
Check with this
IF
(
RangeSum(
CEIL(MAX(KeyFigure1)),
CEIL(AVG(KeyFigure2)),
CEIL(AVG(KeyFigure3)),
CEIL(AVG(KeyFigure4))*1
) < 0,
RangeSum(
CEIL(MAX(KeyFigure1)),
CEIL(AVG(KeyFigure2)),
CEIL(AVG(KeyFigure3)),
CEIL(AVG(KeyFigure4))*1
)
)

Re: Dimension limits with negative values sorted in ascending order in bar chart
mchseifert Dec 7, 2012 4:29 PM (in response to Celambarasan Adhimulam )Hey!
Thanks for your fast feedback! Unfortunately this does not work. I mean if I want to show the largest 10 values it works but not for the smallest 10.... Can this be a bug? However the data I compute with my formula are just a list of values. If I have 30 values computed and 20 of these 30 values are negative I just want to show the Top 10 negative values.....strage behavior.
Do you have some more ideas?
Thanks!!!


Re: Dimension limits with negative values sorted in ascending order in bar chart
Ulrika Da Silva Dec 13, 2012 7:47 AM (in response to mchseifert)Hi,
I have the same problem in a bar chart after upgrade to QV11 SR2; could definetely be a bug. Have you reported it to QT?

Re: Dimension limits with negative values sorted in ascending order in bar chart
mchseifert Dec 13, 2012 8:30 AM (in response to Ulrika Da Silva )Hi,
Thanks for your feedback! No, i don't have reported it to QT! However, I found a workaround, as works as follows: 1st step > Use a RANK function in order to compute the 10 smallest vaules, 2nd step > Compute your values 3rd step > Enable the xaxis scrollbar on the presentation tab
IF
(
NUM(RANK(
IF(
(
CEIL(MAX(KeyFigure1)) +CEIL(AVG(KeyFigure2)) +
CEIL(AVG(KeyFigure3)) 
CEIL(AVG(KeyFigure4)) ) < 0,
RANGESUM(
CEIL(MAX(KeyFigure1)),
CEIL(AVG(KeyFigure2)),
CEIL(AVG(KeyFigure3)),
CEIL(AVG(KeyFigure4))*(1)
)*(1)) ,4)) <= 10,
CEIL(MAX(KeyFigure1)) +
CEIL(AVG(KeyFigure2)) +
CEIL(AVG(KeyFigure3)) 
CEIL(AVG(KeyFigure4))
)Cheers,
Martin.

Re: Dimension limits with negative values sorted in ascending order in bar chart
Sarah Hymers Aug 8, 2013 9:50 AM (in response to mchseifert)I have just discovered this same problem. I want to use "smallest" or "first" in the dimension limits, but then it says "no data to display". I have raised it with QV support.



Re: Dimension limits with negative values sorted in ascending order in bar chart
Miikka Koskinen Dec 12, 2014 11:21 AM (in response to mchseifert)Hi!
You must rewrite your expression. I had same problem with expression like this:
Sum( {set} if( x<y, amount))
/
Sum( {set} if( x<y, amount2))
I changed expression to
Sum( {set} if( x<y, amount/amount2))
and now it works.
Br,
Miikka

Re: Dimension limits with negative values sorted in ascending order in bar chart
Sarah Hymers Dec 12, 2014 11:37 AM (in response to Miikka Koskinen )Miikka I think your before/after expressions could give different results, as division is not an additive function

Re: Dimension limits with negative values sorted in ascending order in bar chart
Miikka Koskinen Dec 12, 2014 11:43 AM (in response to Sarah Hymers)Hi!
You are right. I only made that as a experiment if that bug is expression dependent. I had 4 charts in app and in 2 limiting dimension worked before and in 2 it didn't. I wondered what's the mechanism for that and it was the expression. I have to solve that in script so that I can write simple expression like Sum( {set} amount).
Br,
Miikka
Climber Finland

Re: Dimension limits with negative values sorted in ascending order in bar chart
Sarah Hymers Dec 12, 2014 11:46 AM (in response to Miikka Koskinen )Thanks Miikka.
NB if it helps anyone, when I raised it with support, they confirmed that the expression needed to be rewritten in a different way.


