topic Re: Age limit in QlikView

Age limit

kulasekhar — Wed, 01 Jul 2015 04:25:51 GMT

Hi All

Tab1:

LOAD *

Inline [

Name,Age

A,22

B,21

C,30

D,35

E,41

F,46

G,56

H,67

I,76

J,88

K,10

L,15

];

I want load (age>15) 15 years above data. do not load 15 years below data (do not load: 10,15)

thanks

sekhar.

Re: Age limit

Wed, 01 Jul 2015 04:31:29 GMT

Hi,

Try the below code.

Tab1:

LOAD * Where Age>15;

LOAD *

Inline [

Name,Age

A,22

B,21

C,30

D,35

E,41

F,46

G,56

H,67

I,76

J,88

K,10

L,15

];

Re: Age limit

tresB — Wed, 01 Jul 2015 04:34:23 GMT

Tab1:

LOAD *

Inline [

Name,Age

A,22

B,21

C,30

D,35

E,41

F,46

G,56

H,67

I,76

J,88

K,10

L,15

] Where Age>15;

Re: Age limit

Chanty4u — Wed, 01 Jul 2015 04:39:07 GMT

Hi,

PFA

hope this helps you

Thank you

Suresh chanty

Re: Age limit

Siva_Sankar — Wed, 01 Jul 2015 04:50:38 GMT

Kula Sekhar,

Just add Where Age>15 before the ; Its a matter of filtering.

Re: Age limit

SatyaPaleti — Wed, 01 Jul 2015 05:14:33 GMT

Hi Shekar,

Tab1:

LOAD *

Inline [

Name,Age

A,22

B,21

C,30

D,35

E,41

F,46

G,56

H,67

I,76

J,88

K,10

L,15

] Where Age > 15;