topic Re: Group By ? in QlikView

Group By ?

Thu, 30 Oct 2014 11:03:38 GMT

Hi All,

I want to know hot use group by in QLikview with Some examples is great ful for me ...

Warm,

Heather

Re: Group By ?

MK_QSL — Thu, 30 Oct 2014 11:05:38 GMT

Sales:

Load

Customer,

InvoiceDate,

Sales

From TableName;

TotalSales:

Load

Customer,

SUM(Sales) as TotalSales

Resident Sales

Group By Customer;

Re: Group By ?

senpradip007 — Thu, 30 Oct 2014 11:05:57 GMT

Go through this link http://community.qlik.com/message/507005#507005

Re: Group By ?

its_anandrjs — Thu, 30 Oct 2014 11:10:41 GMT

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

Re: Group By ?

Anonymous — Thu, 30 Oct 2014 11:11:50 GMT

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