Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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;
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;
Thank you.
It'working.
Noobie question