topic Re: Exlude values in QlikView

Exlude values

Thu, 22 Jan 2015 14:03:11 GMT

Hi Experts

I have the following problem:

I gave multiple entries for one person:

I would ONLY like to load the "azmnr" for this person that has the max "marazmnr".

How would I have to script this?

Thank you for your help!

Jan

Re: Exlude values

alexandros17 — Thu, 22 Jan 2015 14:11:24 GMT

this is the code you need:

AAA:
LOAD * Inline [
marnr, fullname, azmnr, model, marazmnr
30, christian, 42, A, 53
30, christian, 42, A, 194
30, christian, 47, B, 167
];

inner Join
LOAD marnr, azmnr, max(marazmnr) as marazmnr Resident AAA Group By marnr, azmnr;