Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

resident

dears,

i want some one here to explain for what

1- resident

2- where cluse

3- and group by

and example of using it

regards

A bDullahk,

1 Solution

Accepted Solutions
Not applicable
Author

Hi Abdullah,

1. Resident --> to load the data from the previous loaded table

Eg

Table 1:

Load a,b,c from xyz.xls

Table 2:

Load a,b,c,b+c as d resident Table1;

2. Where Clause --> is to filter the data during loading

Eg:

Load a,b,c from xyz.xls where a=1; --> it's load only those records where a has value as "1"

3. Group By --> basically used during summation or categorizing the data

Eg:

Load a, b, Sum(c) resident Table1 group by a,b;

Regards

Rajesh

View solution in original post

1 Reply
Not applicable
Author

Hi Abdullah,

1. Resident --> to load the data from the previous loaded table

Eg

Table 1:

Load a,b,c from xyz.xls

Table 2:

Load a,b,c,b+c as d resident Table1;

2. Where Clause --> is to filter the data during loading

Eg:

Load a,b,c from xyz.xls where a=1; --> it's load only those records where a has value as "1"

3. Group By --> basically used during summation or categorizing the data

Eg:

Load a, b, Sum(c) resident Table1 group by a,b;

Regards

Rajesh

View solution in original post