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.
What is group by in qlikview give some best examples please with senario
Aggr function / TOTAL keyword. Have a look here:
Simple example for this to learn the group by
LOAD * Inline
Sum(Sales) as SaleAmt
Group By Month;
DROP Table Source;
In the final table w get the sales value aggregated by the Month field to get the sales value in the single line for each month.
The output is:-
Load ‒ QlikView Help
this is my original senario where i'm facing issue
Table1:LOAD date,id,id as id123, AutoNumberHash256(key,date,id) as mainid, key,region,country,employeeFROMTable1
LOAD date,id, AutoNumberHash256(key,date,id) as mainid, key,region,country,employee,order
load key,date,id,mainid Resident Table1;load key,date,id,mainid Resident Table2;DROP Fields key,date,id,mainid Resident Table1 DROP key,date,id,mainid From Table2;
i want to get the aggregated value of count of id123 from the first table on region,country,employee using group by how can i do it
load * count(id)group by region,country,employee