topic Re: Group by in qlikview in QlikView

Group by in qlikview

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Group by in qlikview

sergio0592 — Tue, 15 Nov 2016 21:05:25 GMT

Aggr function / TOTAL keyword. Have a look here:

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

Re: Group by in qlikview

its_anandrjs — Tue, 15 Nov 2016 21:10:08 GMT

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

Re: Group by in qlikview

MarcoWedel — Tue, 15 Nov 2016 22:32:32 GMT

Load ‒ QlikView Help

Re: Group by in qlikview

Wed, 16 Nov 2016 16:58:25 GMT

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