Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Exlude values

Hi Experts

I have the following problem:

I gave multiple entries for one person:

ScreenShot161.jpg

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

Tags (1)
1 Reply

Re: Exlude values

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;

Community Browser