Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jyothish8807
Not applicable

Error while using min,max ,count aggregations

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

Best Regards,
KC
1 Solution

Accepted Solutions
sreenivas
Not applicable

Re: Error while using min,max ,count aggregations

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;

4 Replies
sreenivas
Not applicable

Re: Error while using min,max ,count aggregations

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;

Not applicable

Re: Error while using min,max ,count aggregations

hi,

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

so

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.

Not applicable

Re: Error while using min,max ,count aggregations

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
Not applicable

Re: Error while using min,max ,count aggregations

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

Best Regards,
KC