topic Re: Error while using min,max ,count aggregations in QlikView

Error while using min,max ,count aggregations

jyothish8807 — Fri, 21 Dec 2012 06:37:49 GMT

LOAD

[Si no], [Email ID], Name, English, Hindi, Maths, Science,max(Science) as Sciencemax

FROM

(ooxml, embedded labels, table is Sheet1);

Iam not able to display the results of " min(Science) " command. its displaying error....

HELP

sreenivas — Fri, 21 Dec 2012 06:43:52 GMT

for this u need to use Group By Clause after the

LOAD

[Si no], [Email ID], Name, English, Hindi, Maths, Science,max(Science) as Sciencemax

FROM

(ooxml, embedded labels, table is Sheet1)

Group By

[Si no], [Email ID], Name, English, Hindi, Maths;

Fri, 21 Dec 2012 06:45:18 GMT

hi,

to use aggregate functions like min, max count, we have to use group by cluase.

first u load:

Student:

LOAD

[Si no], [Email ID], Name, English, Hindi, Maths, Science

FROM

(ooxml, embedded labels, table is Sheet1);

Then load

load [Si no],

max(Science) As Sciencemax

resident Student

group by [Si no];

hope it helps you.

Niranjan M.

Fri, 21 Dec 2012 06:51:03 GMT

hi,

use according to this example,

Load Month, min(Sales) as SmallestSalePerMonth from abc.csv group by Month;

Load Month, min(Sales, 2) as SecondSmallestSalePerMonth from abc.csv group by Month;

hope it help you.

jyothish8807 — Fri, 21 Dec 2012 13:13:43 GMT

Is it compulary to use a group by statement? Is there any alternative way without using group by...