Issue in following script !!

[nikhilgarg]

Hey,

I am facing an issue in following code:

Data1:

LOAD Months,

      Value,

      Previous(Value) as Previous_Value,

//MissingCount(Item) as CountOfMissingItem,

FieldValue('Months' , 1) as FName

FROM

(ooxml, embedded labels, table is Sheet1) ;

In the output nothing is printed under the FName column.

Why is it so ? Please xplain.

Thanks.

[Anonymous]

Hi Nikhil,

Order by works with Resident table because Qlikview doesn't recognize Order by  with Datafiles and QVD's.

Hence we need to load data from Datafiles and QVD's and if Order by required use it on Resident table.

Regards

Nitha

[nikhilgarg]

So does that mean that let say i have a field:  Values having value (1,2,5,4,3).

Then if i load it using Resident Load then data will be loaded in Ascending or descending order ??

Is it so ??

[nikhilgarg]

So does that mean that let say i have a field:  Values having value (1,2,5,4,3).

Then if i load it using Resident Load then data will be loaded in Ascending or descending order ??

Is it so ??

[tresesco]

If you don't mention any sort order it takes ASC (ascending) by default. Otherwise you can explicitly mention like:

Load

          *

Resident <> Order By Asc/Desc FieldName, ...;

[Anonymous]

Hi,

Yes by default Order by sorts Asc ,you need to specify for Desc.

Regards

Nitha

[nikhilgarg]

Hey,

Thanks for this explanation.

So , what i understand from above conversation is :

Field value works with Only "Resident Load" and by default it takes the field value in ascending order.

In ordinary load , FieldValue does not works well.

Am i right ??

[nikhilgarg]

Hey,

Thanks for this explanation.

So , what i understand from above conversation is :

Field value works with Only "Resident Load" and by default it takes the field value in ascending order.

In ordinary load , FieldValue does not works well.

Am i right ??

[tresesco]

Yes, it seems so.

[nikhilgarg]

THanks.

[Anonymous]

Hi,

Mostly functions are most effective when used on resident load than on direct loads.

Regards

Neetha