Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Group by in qlikview

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

4 Replies
sergio0592
Specialist III
Specialist III

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

  

MonthSaleAmt
Apr600
June1800
May400

Regards

Anand

MarcoWedel

Not applicable
Author

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