Has anyone encountered an issue using FieldValue()?
FieldValue('ColumnA',IterNo()) as ColumnA
While not Isnull(FieldValue('ColumnA',IterNo()))
It works for some columns and not for others. It makes no sense. Some columns, it will load in all the correct values. For other columns, it will load in several instances of a questions mark. Yes, the values show up as "?".
And yet, for another column, it loads in nothing at all.
I've tired everything from renaming columns to aliasing differently and I can't find a pattern as to why this doesn't work. Super frustrating. Anyone have any solutions?
QlikView is struggling with the string-intepretation from this value and showed only a ? as placeholder. But if you forced an additionally string-intepretation per num() or dual() the correct values will be displayed. see also: Re: Problem with FieldValue
I am not surprised. I think you use the FieldValue() function in a way that you shouldn't.
The FieldValue(fieldname,n) function returns the field value found in position n of the field. In other words: It accesses the symbol tables to get the n:th field value. But you use the function like
I.e. you use the function in the same Load statement that is about to define the symbol table for ColumnA (in red). Of course you can then get into a recursive definition. Or worse; the memory for the n:th position of the symbol table is perhaps already allocated, but has not yet been assigned a value.
I am struggling with Fieldvalue () function in a loop:
I have an Excel table with the following data:
I create a loop to concatenate multiple QVDs and have a single table with all QVD names and fields:
it works perfect when I do not have equals Folder names in the Excel. However, when having the same Folder name, the LET vQVDFolder= FieldValue ('Folder' $(i)); does not saved the Folder name in the variable.