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 have this Load script and am trying to flag the max and min within the load script.
Anyone with an idea of what the best method will be to achieve the required result
load * inline [
Type, Month, Amount
left join (temp)
load Type,Month, max(Amount) as Amount, 1 as Rank resident temp group by Type,Month;
//this can be omitted
Load Type, Month, Amount, if(isnull(Rank),0,1) as Rank resident temp;
DROP TABLE temp;
View solution in original post
if(Type<>Previous(Type),0,1) as Rank
order by Type, Month, Amount;
DROP Table Data;
(html, codepage is 1252, embedded labels, table is @1);
If((Type <> Previous(Type)),0,1) as Rank
Resident WebData Order by Type;
DROP Table WebData;