Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
kulasekhar
Creator
Creator

Age limit

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.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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;

View solution in original post

5 Replies
Not applicable

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

];

tresesco
MVP
MVP

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;

Chanty4u
MVP
MVP

Hi,

PFA

hope this helps you

Thank you

Suresh chanty

Siva_Sankar
Master II
Master II

Kula Sekhar,

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

SatyaPaleti
Creator III
Creator III

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;