Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
there is a check box in the dimension page: "Suppress when value is null", try to check and let me know
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
I don't see this attribute
it is an list box object I want to hide if there are no values
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)
I want to hide/show a selection box if there are no values in it at all.
IN the layout tab there is a "show" section, in conditional write:
GetPossibleCount(myField) > 0
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
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.
thx works like a charm!