topic Re: If Expression in QlikView

If Expression

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to fill my Listbox only with fields that have field_type 'date'.

I used this expression, but it shows all values of the table. Although But I have different Field_types.

=if(Field_Type = 'Date'),$Field)

Br,

Re: If Expression

Anil_Babu_Samineni — Wed, 02 Nov 2016 15:28:41 GMT

Try this

=if(match(Field_Type , 'Date'),Field_Type)

Re: If Expression

Wed, 02 Nov 2016 15:35:32 GMT

Hi Anil,

Thanks for the reply.

I want to generate the Fieldnames ($Field). But only when the field_type = 'Date'. It seems not to work for me?

Thanks,

Mathias

Re: If Expression

sunny_talwar — Wed, 02 Nov 2016 15:42:33 GMT

Field_Type is a field that comes from the data? May be you need this:

If(WildMatch(Lower($Field), '*date*'), $Field)

Re: If Expression

Fri, 04 Nov 2016 14:40:49 GMT

Hi Sunny,

Field_Type indeed comes from the data. Every Field, has also a Field_Type. Depending on the Field_type (the ones which = 'date'), I want to see the $Field.

Is my question clear?

Br,

Re: If Expression

sunny_talwar — Fri, 04 Nov 2016 16:32:52 GMT

May be this?

If(WildMatch(Lower(Field_Type), '*date*'), $Field)

Re: If Expression

Mon, 07 Nov 2016 12:10:10 GMT

This is the table I have:

Field	FieldType
Name	Normal
Address	Normal
StartDate	Date

I want only the field in the listbox when Fieldtype = 'Date'.

Purpose is to have another listbox with the other fields when FieldType is 'Normal'.

So I want to split up the fields according field_type.

Br,

Mathias

Re: If Expression

sunny_talwar — Tue, 08 Nov 2016 01:47:12 GMT

May be this?

If(WildMatch(Lower(Field_Type), '*date*'), Field)

and for normal, may be this:

If(not WildMatch(Lower(Field_Type), '*date*'), $Field)

Re: If Expression

Tue, 08 Nov 2016 11:10:07 GMT

Hey Sunny,

Thank you very much. It works now.

But can you explain me the difference between your first and second solution?

Best regards,

Re: If Expression

sunny_talwar — Tue, 08 Nov 2016 11:53:03 GMT

You mean difference between these two expressions

If(WildMatch(Lower(Field_Type), '*date*'), Field)

and

If(WildMatch(Lower(Field_Type), '*date*'), $Field)

I guess you were using $Field before and I changed it to Field