Length of a field

[shanky1907]

Hello all,

I want to use a calculated dimension on one of my chart. as if it contains no vlaue then there should be '-' otherwise the value itself.

I was using length function till now, but it cant help me.

Please help me with this.

Thanks in advance

[#2]

Suppose mDimension is - for now

then If IsNull(mDimension) = 1   works better than comparing to "-"

[#3]

and if your have a an IF condition, then IF (blalala, truevaluereturned, Null())

here Null() returns the representation of Nothing in the dimension, which is display by the symbol - by Qview by default.

[shanky1907]

i used it with if condition as if(len('FieldName')=0,'-','FieldName'). But it doesnt work.

[rwunderlich]

These "no value" dimensions, are they Null values or Missing values?

-Rob

[Anonymous]

Hi,

If you want to filter by NULL values, use below code in the script like:

LOAD If(IsNull(FIELDNAME), '-', FIELDNAME) as FIELDNAME

....

From TableName;

Regards

Neetha

[#7]

=IF (isNull(FieldName) = 1 , '-', FieldName)

[shanky1907]

I want to change on the chart only...not in the script..

[shanky1907]

These are null values.