Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

If row value changes

Hello everybody,

I'm new here and this is my first question.

Im trying to get a moving MAX value for the colummn MENGE which should change, when the text value on the colummn ARTNR also changes. I'm looking for the MAX MENGE value for each article and this value should be displayed and repeated for all the rows with the same ARTNR.

Here you have the structure of my data. It ´d be very glad if you could help me.

Thank you very much

Urdru.

ARTNRLHMNRSEKTORNRMENGE
-
000.3-60-0000.5-L4301723
000.3-60-0000.5-L4303029
000.3-60-0002.0-L4169913
000.3-60-0003.0-L4209221
000.8-42-2-R4264626
000.8-42-8-L4272413
000.8-42-10-L43016215
000.8-42-10-R4259117
000.8-42-16-R4232515
000.8-42-24-R4306425
000.8-42-40-L42634216
000.8-42-40-R4260821
000.8-42-50-R4283912
000.8-42-72-R4296523
000.8-42-100-L42605216
000.8-60-4-L4183518
000.8-60-6-L4210723
000.8-60-8-R42280210
000.8-60-10-L42782211
000.8-60-16-R4199733
000.8-60-24-L4181341
1 Solution

Accepted Solutions
MVP
MVP

Re: If row value changes

Maybe adding to your script:

Left Join (YourTable) LOAD ARTNR, max(Menge) as MaxMenge resident YourTable group by ARTNR;

2 Replies
MVP
MVP

Re: If row value changes

Maybe adding to your script:

Left Join (YourTable) LOAD ARTNR, max(Menge) as MaxMenge resident YourTable group by ARTNR;

Not applicable

Re: If row value changes

Thank you very much swuehl for you quick and certain answer. It runs perfectly.

MfG

Urdru