THanks for the quick feedback guys.
Good thinking . Database definition of the field is NUMBER.
The measure field when displayed within tablebox is left aligned.
When I 'double load' the measure as a dimension and do the ISNUM check, all come through as -1. QV also identifies the dimension as numeric,integer. The dimension value in listbox is right aligned.
I also tried converting the measure even though database type is numeric, but no change. So I think you may be onto something in that QV is interpreting it as a string although everything looks ok?
Wouldn't that be within load script? My script syntax here is pure SQL since no preceding loads are allowed, or am I off here.
No I have not, let me try aggr real fast and see if there is any change.
I am relatively novice when it comes to Direct Discovery. So pardon me for not understanding some of the terminology here. What does 'double load' mean? Is it Direct Discovery related thing? Also, I am confused: you mentioned that in the table box the Field is left aligned, but in the list box its right aligned??? Not sure I completely understood your findings.
No worries Sunny, first time use case for DD for me as well.
Double load means I brought the same field in as a measure and a dimension.
What I was trying to say by left aligned and right aligned is QV is displaying one as a number and the other as a string. With QV though I know I can't always count on the display, it's just I can't see what type it thinks the measure value is outside of putting it in a listbox or tablebox.
I tried aggr(max(FIELD),DIM) and get the max value, sum(aggr(max(FIELD),DIM)) and get max value. aggr(sum(FIELD),DIM) and I get null.
Not sure what you mean by this?
Thanks for all feedback.
I have been dabbling a bit with DD mostly on trial and error basis so I _can_ be fishing in the wrong pond here...
My discoveries (pun intended) is that you have to aggregate. A measure does not seem to be able to have multiple values (be on several lines). That's why it works when using max() as Max() gives you one value only.
I'm sorry if I'm not very clear, but I don't quite understand this enough to express myself clearer. :-) For what it's worth, I hope this helps.
Maybe you need to sum the lines in the db using native (sql) commands.