Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
settu_periasamy
Master III
Master III

Between value Selection (<= and >=)

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.

Capture.JPG.jpg

find the below sample data.

1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

This is very old version.

I would definitely recommend to upgrade to latest version.

Hope it helps

Regards

ASHFAQ

View solution in original post

35 Replies
danieloberbilli
Specialist II
Specialist II

I think you only missed one zero as your max-value is actually smaller than your min value

70002014014 instead of 7002014014

settu_periasamy
Master III
Master III
Author

Hi Daniel,

that was typo mistake. In the screen shot it is entered correctly.  i corrected on that. Could you please check the sample application. and look on the screen shot?

danieloberbilli
Specialist II
Specialist II

I think it works fine: or am I missing something?

Capture51.PNG.png

Not applicable

put  , in middle

settu_periasamy
Master III
Master III
Author

Hi Daniel,

This is what exactly i need. But for me, the same expression shows extra data. see the below screen shot for me.

Capture.JPG.jpg

danieloberbilli
Specialist II
Specialist II

I have no idea what could be the reason for that - try to Clear your selection, do it again and hit the Go-button of Advanced Search...maybe you had first a typo and didn't hit the go-button again?

settu_periasamy
Master III
Master III
Author

I tried the same. but not get the result. is there any limit for the number value?

aveeeeeee7en
Specialist III
Specialist III

Hi Settu

Use Button Search and write Expression:

='>=$(=70002014000)' & '<$(=70002014015)'

Snapshot:

Date Range Selection.png

Also, See the Attachment.

Regards

Av7eN

danieloberbilli
Specialist II
Specialist II

could it be that you copied and paste the search expression and there is maybe a (hidden) layout symbol that comes sometimes if trying to copy&paste stuff from word/excel/powerpoint. If so - try to type it again