hide select field when is empty

[#1]

Hi,

Is there a QV function to see if a select field/dimension is empty. I want to hide the select field if there is no dimension value.

[alexandros17]

there is a check box in the dimension page: "Suppress when value is null", try to check and let me know

[PrashantSangle]

Hi,

try Isnull(FieldName)

or len(trim(fieldName))=0

If you want hide empty/Null field from chart then you can click on supress when value is null from Dimesion tab.

Regards

[#4]

I don't see this attribute

it is an list box object I want to hide if there are no values

[alexandros17]

Ok, then write:

in the general tab, at the bottom of field name list there is an tem "Expression", select it and write

If(trim(myDimension)='', null(), myDimension)

[#6]

I want to hide/show a selection box if there are no values in it at all.

[alexandros17]

IN the layout tab there is a "show" section, in conditional write:

GetPossibleCount(myField) > 0

[PrashantSangle]

Hi

Write in expression with if()

like

if(len(trim(fieldName))>0,FieldName)

Or write this in Script

if(len(trim(fieldName))>0,FieldName) as New_fieldName,

Regards

[Gysbert_Wassenaar · Accepted solution]

What do you mean with 'empty'? No data values loaded? Then the fieldvaluecount('MyFieldHere') will be 0. You can use that as a conditional expression on the Layout tab for a listbox or for the conditional expression on the Dimensions tab for a dimension in a chart.

[#10]

thx works like a charm!