order by and FieldValue

ali_hijazi — Wed, 23 Nov 2011 14:49:37 GMT

Hello

I got a table sorted as follows:

Item_id asc, Sale_Date desc

if i preview the table in the table viewer I get first the item id 26 repeated several times depending on the number of transactions

However now I'm applying a loop as follows:

let vRecords = NoOfrows('myTable');

for i=1 to $(vRecords)

let x = FieldValue('Item_id',$(i))

if I debug the script I get the first item to be 3294 which is not 26 as I'm seeing it in the previewer

what could be the problem?

please Advise

swuehl — Wed, 23 Nov 2011 14:58:26 GMT

FieldValue will access the internally stored compressed Field with index given by unique value in load order.

That could explain the difference.

Try using peek() function instead:

for i=0 to $(vRecords)-1

let x = Peek('item_id',$(i),'myTable')

Hope this helps,

Stefan

topic order by and FieldValue in QlikView