Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to know hot use group by in QLikview with Some examples is great ful for me ...
Warm,
Heather
Hi,
Very simple example suppose i need to sum up the values of the regions in the back end so i group the sales sum in the regions wise.
Source:
LOAD * Inline
[
Region,Customer,Sales
R1,C1,4863
R2,C2,1263
R3,C2,1475
R3,C3,1256
];
Query:
Load
Region,
Sum(Sales) as SaleAmt
Resident Source
Group By
Region;
Then i get another table as Sum up sales with region
Region | SaleAmt |
R1 | 4863 |
R2 | 1263 |
R3 | 2731 |
Hope this helps
Anand
Sales:
Load
Customer,
InvoiceDate,
Sales
From TableName;
TotalSales:
Load
Customer,
SUM(Sales) as TotalSales
Resident Sales
Group By Customer;
Go through this link http://community.qlik.com/message/507005#507005
Hi,
Very simple example suppose i need to sum up the values of the regions in the back end so i group the sales sum in the regions wise.
Source:
LOAD * Inline
[
Region,Customer,Sales
R1,C1,4863
R2,C2,1263
R3,C2,1475
R3,C3,1256
];
Query:
Load
Region,
Sum(Sales) as SaleAmt
Resident Source
Group By
Region;
Then i get another table as Sum up sales with region
Region | SaleAmt |
R1 | 4863 |
R2 | 1263 |
R3 | 2731 |
Hope this helps
Anand
HI!
The group by clause is used to retrieve data depending of one or more columns. For example:
LOAD
Product,
Customer,
sum(qty) as Quantity
FROM
Test.qvd(qvd)
GROUP BY Product, Customer;
This sentence will bring will return the Quantity column as a sum o qty grouped by the diferents combinations of Product and Customer. Group by clause must include all fields where there's no agregation on it.
Regards,
Gabriel