topic Re: Date Field filtering from a list of fields in QlikView

Date Field filtering from a list of fields

pipuindia99 — Thu, 25 May 2017 09:44:45 GMT

Hi,

Need a help to pull only the fields which has dates in,

for eg., $(Fields) will give the list of fields present in that QV or table. I need to find the fields at a time which has only dates(any format).

Re: Date Field filtering from a list of fields

micheledenardi — Thu, 25 May 2017 10:10:38 GMT

There are no data types in QlikView Data Types in QlikView.

There are different presentation of the numeric data, that's it. But you can't even say that a given column is a numeric or a text, because both numeric and string values can be in the same column in QlikView.

Re: Date Field filtering from a list of fields

vishsaggi — Thu, 25 May 2017 12:06:54 GMT

Can you share some sample date values you are getting from your source?

Re: Date Field filtering from a list of fields

pipuindia99 — Thu, 25 May 2017 12:22:26 GMT

Hi,

Attached a screenshot, if you see in that whichever field has date values should be listed out in separate list box

for eg., in the screenshot changegroup_created is a field which has date values, similarly there would be different fields which has date values, i need to identify which are those fields and have to list it out separately.

Re: Date Field filtering from a list of fields

ahaahaaha — Thu, 25 May 2017 12:22:55 GMT

Hi,

Maybe this discussion will help you how to get values for $Field‌

Regards,

Andrey

Re: Date Field filtering from a list of fields

pipuindia99 — Thu, 25 May 2017 13:38:35 GMT

Hi,

I read the discussion, not sure it helps me...

Re: Date Field filtering from a list of fields

vamsee — Thu, 25 May 2017 13:44:56 GMT

The best suggestion I would give is

First 100 Load

Create a table box with all columns and filter out

Re: Date Field filtering from a list of fields

juliedecoene — Thu, 25 May 2017 14:35:13 GMT

Hi,

Here is an example for numeric fields, that you would need to adapt for dates. Unfortunately, I believe the "any format" for dates may be difficult to catch; you will have to come up with a very smart rule to test that out...

NumFields:

LOAD * Inline [NumField];

FOR i = 0 to NoOfTables()-1

vTable = TableName($(i));

FOR j = 1 to NoOfFields('$(vTable)')

vField = FieldName($(j),'$(vTable)');

temp:

NoConcatenate

LOAD

Sum(If(IsNum([$(vField)]),1,0)) as FieldIsNum

Resident $(vTable);

vFieldIsNum=Peek('FieldIsNum', 0, 'temp');

If vFieldIsNum = NoOfRows('$(vTable)') then

Concatenate(NumFields)

LOAD

'$(vField)' as NumField

AutoGenerate(1);

ENDIF

DROP Table temp;

NEXT j

NEXT i