topic Re: Between value Selection (<= and >=) in QlikView

Between value Selection (<= and >=)

settu_periasamy — Wed, 12 Nov 2014 03:04:14 GMT

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.

Re: Between value Selection (<= and >=)

danieloberbilli — Wed, 12 Nov 2014 03:17:57 GMT

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

70002014014 instead of 7002014014

Re: Between value Selection (<= and >=)

settu_periasamy — Wed, 12 Nov 2014 03:22:16 GMT

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?

Re: Between value Selection (<= and >=)

danieloberbilli — Wed, 12 Nov 2014 03:28:24 GMT

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

Re: Between value Selection (<= and >=)

Wed, 12 Nov 2014 03:30:27 GMT

put , in middle

Re: Between value Selection (<= and >=)

settu_periasamy — Wed, 12 Nov 2014 03:31:56 GMT

Hi Daniel,

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

Re: Between value Selection (<= and >=)

danieloberbilli — Wed, 12 Nov 2014 03:34:25 GMT

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?

Re: Between value Selection (<= and >=)

settu_periasamy — Wed, 12 Nov 2014 03:36:58 GMT

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

Re: Re: Between value Selection (<= and >=)

aveeeeeee7en — Wed, 12 Nov 2014 03:38:28 GMT

Hi Settu

Use Button Search and write Expression:

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

Snapshot:

Also, See the Attachment.

Regards

Av7eN

Re: Between value Selection (<= and >=)

danieloberbilli — Wed, 12 Nov 2014 03:40:27 GMT

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

Re: Between value Selection (<= and >=)

settu_periasamy — Wed, 12 Nov 2014 03:49:13 GMT

Hi Av7eN,

When i clicked the button Range Selection, i get the data like below (Note: i dont change anything in your data, just i clicked the range selection button.

i think, it is happen, only for me.

Re: Between value Selection (<= and >=)

settu_periasamy — Wed, 12 Nov 2014 03:50:29 GMT

this is not working manoj...

Re: Between value Selection (<= and >=)

aveeeeeee7en — Wed, 12 Nov 2014 03:55:56 GMT

It is working fine for me.

Re: Between value Selection (<= and >=)

settu_periasamy — Wed, 12 Nov 2014 03:58:12 GMT

Do i need to do any setting change in document properties or user prefrence?

Re: Between value Selection (<= and >=)

settu_periasamy — Wed, 12 Nov 2014 03:59:23 GMT

i tried daniel. But still it is not working for me. is there any setting for like integer, double like that?

Re: Between value Selection (<= and >=)

danieloberbilli — Wed, 12 Nov 2014 04:04:32 GMT

are you using the exact same file that you uploaded? If not - maybe you have another currently active selection(maybe by a trigger that is not obvious for you?)

Re: Re: Between value Selection (<= and >=)

aveeeeeee7en — Wed, 12 Nov 2014 04:13:57 GMT

PFA.

Please share the full Qlikview screen snapshot with me after doing Clear All and Selecting Range Selection Button.

Regards

Av7eN

Re: Between value Selection (<= and >=)

settu_periasamy — Wed, 12 Nov 2014 04:45:44 GMT

Hi ,

Please find the below screen shot. and Can you tell me your version of QV. Mine is v11.00

Re: Between value Selection (<= and >=)

settu_periasamy — Wed, 12 Nov 2014 04:49:37 GMT

Yes Daniel, There is two fields only. First i cleared all then i tried. And This is not working for my collegues too..;

========================= QlikView Info ==========================

Client Build Number 11.00.11282.0409

Server Build Number -

QlikTech Product QlikView 64-bit Edition (x64)

License Key [Leased license]

PE Recoveries Remaining 2

CPU Target x64

Re: Between value Selection (<= and >=)

aveeeeeee7en — Wed, 12 Nov 2014 05:00:43 GMT

That's a Strange behavior.

I am using 11.20 SR6