Discussion board where members can get started with QlikView.
[Si no], [Email ID], Name, English, Hindi, Maths, Science,max(Science) as Sciencemax
(ooxml, embedded labels, table is Sheet1);
Iam not able to display the results of " min(Science) " command. its displaying error....
Go to Solution.
for this u need to use Group By Clause after the
(ooxml, embedded labels, table is Sheet1)
[Si no], [Email ID], Name, English, Hindi, Maths;
to use aggregate functions like min, max count, we have to use group by cluase.
first u load:
[Si no], [Email ID], Name, English, Hindi, Maths, Science
load [Si no],
max(Science) As Sciencemax
group by [Si no];
hope it helps you.
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.
Is it compulary to use a group by statement? Is there any alternative way without using group by...