topic Re: index in QlikView

index

Fri, 05 Dec 2014 11:47:10 GMT

i have filed

Sal

100

200

300

here i want to find the of 300 sal in sal table

Re: index

Fri, 05 Dec 2014 11:49:29 GMT

HI,

here i want to find the of 300 sal in sal table - what it means

Re: index

Fri, 05 Dec 2014 11:55:47 GMT

means index location of 300

i used index(sal,300) butt return 0 when i used index(sal,100) return 1 ?

Re: index

its_anandrjs — Fri, 05 Dec 2014 12:16:03 GMT

It will return 1 every time with not index value because it is

Check with this if you load you can find 4 and 7 because it is this locations

LOAD Sal,

Index(Sal,200) as Index200,

Index(Sal,300) as Index300;

LOAD * Inline

[

Sal

100200300

];

Regards

Anand

Re: index

rubenmarin — Fri, 05 Dec 2014 12:22:31 GMT

Hi hammad, maybe FieldIndex('Sal', 300), QV only stores different values so for a table like:

Sal

100 -->Index 1

200 -->Index 2

100 -->Index 1 (is a value previously loaded)

300 -->Index 3

The Index() funtion you are using to return the position where a substring starts in a string, ie:

Index('ABC', 'B') --> Returns '2'

Re: index

Peter_Cammaert — Fri, 05 Dec 2014 12:23:21 GMT

Lookup() may be helpful, though it's (still) a script-only function.

Like in:

RawData:

LOAD RowNo() AS RNo, Sal INLINE [

Sal

100

200

300

];

LET vIndex = Lookup('RNo', 'Sal', 300);

If you want to use this value in the User Interface, can you provide us a few more details about what you are up to?

Peter

Re: index

Fri, 05 Dec 2014 12:24:41 GMT

i think

it wont work

because u have to use only strings in index function .

ex:

index('apple','e') it returns 5