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]

stalwar1‌

sunny help me

[stonecold111]

jagan‌

swuehl‌

help me

[Anil_Babu_Samineni]

In fact, You should not use the Wild card like *<0*. It should be <0 and i am not sure why do you need -1 over the expression. I've removed and applied it's working

(sum(colum1)-sum(column2)-sum(column3))

[stonecold111]

yes i am using <0 only not *'s

and i need -1 in my expression. i need that in my expression. what is the problem with that -1

it just changes positive to negative. stiill qlikview should filter . don;t ask me to remove -1

anyway thanks

[Anil_Babu_Samineni]

May be straight table recognize the -ve values because of -1. I thought so.

don;t ask me to remove -1

Why Should I, That is your project. I am asking about what is the use of -1 over there

it just changes positive to negative

Is there any requirement to get +ve to -ve values or for formality you have written over there? If so fine. Anyway wait some time may be experts reply to you

[stonecold111]

yes .  my requirement is to get positive and negative values for that expression.

i don't know why qlikview can't give correct results for basic expression

[swuehl]

The reason why you get an 'incorrect' filter is due to the fact that selections are made on dimensional field values, not on the expression values.

If you look at the dimensional values related to negative measure, you'll notice that the line with 4599 shows also dimensional values that appear in any other line with negative measure.

To overcome this, you would need to make your dimensions a primary key.

[stonecold111]

Plz explain briefly. how to make dimension a primary key

[stonecold111]

and why selections are made on dimensional fields when i am searching in measure filed