Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Min of group by

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

RangeREF1REF2
0ref-AREF2-1
1ref-AREF2-2
5ref-AREF2-3
0ref-BREF2-4
6ref-BREF2-2
1ref-CREF2-223
0ref-CREF2-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.

1 Solution

Accepted Solutions
sunny_talwar

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;

View solution in original post

3 Replies
sunny_talwar

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;

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

Thank you.

It'working.

Noobie question