searchable in straight table not working

[stonecold111]

Hi qliksss

I am attaching both xls and qvw file

i have one expression for which i enabled searchable. but i wen i give <0 . it is giving positive value also 4599

this is sample data. like this i am getting so many positive values for <0  and so many negative values for >0

what could be the reason. is there anyway that i can get >0 and <0 values accurately

for <0

-

`     `press enter then

measure 4599 is coming for <0 .... Plz suggest qlikssss

Thanks in advance

[stonecold111]

and why selections are applied on fields when i am searching in my measure

[swuehl · Accepted solution]

LOAD AutoNumberHash256(name,id,desc,group) as Key,

  name,

    id,

    desc,

    group,

    colum1,

    column2,

    column3

FROM

[HI.xls]

(biff, embedded labels, table is Sheet1$);

Add Key field to your dimensions (you can hide the column on presentation tab).

[bouderbc]

Dimension : Year

Measure: sum (sales)

Needs 1: N and N-1 in the same Graph

---------2: N and the 13 th Month

Thanx Omar for ur help !

[stonecold111]

Hi Stefan,

If i give autonumberhash function it is changing my measure values .

now its giving different values. this is just sample data

Now >0 and <0 working .. but values for measure field is showing different values

is there any other way

[stonecold111]

Ok. Thanks.. working fine