Group by in qlikview

[#1]

What is group by in qlikview give some best examples please with senario

[sergio0592]

Aggr function / TOTAL keyword. Have a look here:

https://community.qlik.com/thread/35626

[its_anandrjs]

Simple example for this to learn the group by

Source:

LOAD * Inline

[

Month,OrderID,Sales

Apr,1,100

Apr,2,200

Apr,3,300

May,4,100

May,5,300

June,6,500

June,7,600

June,8,700

];

Final:

LOAD

Month,

Sum(Sales) as SaleAmt

Resident Source

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:-

Month	SaleAmt
Apr	600
June	1800
May	400

Regards

Anand

[MarcoWedel]

Load ‒ QlikView Help

[#5]

Hi

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,
employee
FROM
Table1

Table2:

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