topic Re: hide select field when is empty in QlikView

hide select field when is empty

Fri, 13 Mar 2015 09:53:47 GMT

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.

Re: hide select field when is empty

alexandros17 — Fri, 13 Mar 2015 09:56:31 GMT

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

Re: hide select field when is empty

PrashantSangle — Fri, 13 Mar 2015 09:58:21 GMT

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

Re: hide select field when is empty

Fri, 13 Mar 2015 10:00:16 GMT

I don't see this attribute

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

Re: hide select field when is empty

alexandros17 — Fri, 13 Mar 2015 10:05:37 GMT

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)

Re: hide select field when is empty

Fri, 13 Mar 2015 10:05:47 GMT

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

Re: hide select field when is empty

alexandros17 — Fri, 13 Mar 2015 10:10:55 GMT

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

GetPossibleCount(myField) > 0

Re: hide select field when is empty

PrashantSangle — Fri, 13 Mar 2015 10:12:27 GMT

Write in expression with if()

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

Or write this in Script

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

Regards

Re: hide select field when is empty

Gysbert_Wassenaar — Fri, 13 Mar 2015 10:21:52 GMT

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.

Re: hide select field when is empty

Fri, 13 Mar 2015 10:46:37 GMT

thx works like a charm!

Re: hide select field when is empty

Thu, 26 Mar 2015 09:51:24 GMT

this work like a bom, thanks.