topic Distinguishing between data types in one field in QlikView

Distinguishing between data types in one field

Mon, 08 Mar 2010 13:21:22 GMT

HI guys,

I have a field which contains an integer such as 975846 but it also contains date inputs in the format of 14/03/2010.

I would like to be able to count each type of input separately. is there a way to distinguish between the two when doing a count, possibly using the LIKE function? Any help would be much appreciated.

Thanks

Distinguishing between data types in one field

Miguel_Angel_Baeyens — Mon, 08 Mar 2010 13:25:43 GMT

Hello,

Is there any kind of separator between both values? Could you post an example of a couple of values for that field? There are some string functions you can use to separate values in a field, and like function exists as well.

Distinguishing between data types in one field

Mon, 08 Mar 2010 13:27:53 GMT

Hi,

Here you are a possible solution.

I hope this helps you.

Best regards.

Distinguishing between data types in one field

Mon, 08 Mar 2010 14:40:07 GMT

Thanks Miguel,

That works for me!