Min of group by

[Anonymous]

Hi everyone ,

Newbie on QLIK SENCE , I'm trying to find the min of a couple of information:

In my example there is 3 columns

Range	REF1	REF2
0	ref-A	REF2-1
1	ref-A	REF2-2
5	ref-A	REF2-3
0	ref-B	REF2-4
6	ref-B	REF2-2
1	ref-C	REF2-223
0	ref-C	REF2-2

I would like to have 0,ref-A,REF2-1 / 0,REF-B,REF2-4/0,ref-C,REF2-2.

When I use the expression Load min(Range) , REF1,REF2 group BY REF1,REF2, QLIK sence give me all the line (because of it calculate the min per group by).

how can I found what I'm expects?

Thank you.

[sunny_talwar · Accepted solution]

Why don't you just do a Group By REF1 and right join into your main table like this

Table:

LOAD Range,

     REF1,

     REF2

FROM ....;

Right Join (Table)

LOAD Min(Range) as Range,

     REF1

Resident Table

Group By REF1;

[Anil_Babu_Samineni]

Try this?

File:

LOAD Range,

     REF1,

     REF2

FROM

[https://community.qlik.com/message/1503504]

(html, codepage is 1252, embedded labels, table is @1);

Right Join(File)

LOAD Min(Range) as Range, REF1 Resident File Group By REF1;

[Anonymous]

Thank you.

It'working.

Noobie question