This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
i want some one here to explain for what
2- where cluse
3- and group by
and example of using it
1. Resident --> to load the data from the previous loaded table
Load a,b,c from xyz.xls
Load a,b,c,b+c as d resident Table1;
2. Where Clause --> is to filter the data during loading
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
Load a, b, Sum(c) resident Table1 group by a,b;
View solution in original post