Between value Selection (<= and >=)

[settu_periasamy]

Hi All,

This is regarding the between value for the data. when i give the condition using the Advanced search, it's selected the extra data.

find the below screen shot and sample data. In the below screen shot i given the condition between >=70002014000 <=70002014014. But in the BDN field, it's selected till 70002014017.

find the below sample data.

[danieloberbilli]

did you try to create a 'Current Selection' object - to see if there is some triggered (and locked) selection in the background?

[settu_periasamy]

i tried that also.. see the below screen shot..

It is working for 9 digit like >=702014000<=702014014. But i need the 11 digit value.

Really get confusion of this.

[vinay_hg]

try to convert the values to number format and compare.

[settu_periasamy]

That field is already number. Can you please suggest how to convert it?

[ashfaq_haseeb]

Hi,

Can you share sample application of yours to look over.

Regards

ASHFAQ

[settu_periasamy]

Already attached.

http://community.qlik.com/servlet/JiveServlet/download/654262-136990/qv_comm_help_bd.qvw

[settu_periasamy]

Any Suggestions ?

[ashfaq_haseeb]

Hi,

Check this this works fine for me.

Have a look at attached application and image.

Use this in your search tab

>=70002014000<=70002014014

Make sure you copy the exact thing.

Check that there is difference in your numbers

Let me know if that worked.

Regards

ASHFAQ

[settu_periasamy]

Hi Ashfaq,

Exactly i did as you said. Please find the below screen shot what i get.

[ashfaq_haseeb]

Try like this

>=70002014000<=7002014014

You same string

Regards

ASHFAQ