Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
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.
Can you share some sample date values you are getting from your source?
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.
Hi,
I read the discussion, not sure it helps me...
The best suggestion I would give is
First 100 Load
Create a table box with all columns and filter out
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