If row value changes

Mon, 18 Jun 2012 14:24:05 GMT

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.

ARTNR	LHMNR	SEKTORNR	MENGE
			-
000.3-60-0000.5-L	43017	2	3
000.3-60-0000.5-L	43030	2	9
000.3-60-0002.0-L	41699	1	3
000.3-60-0003.0-L	42092	2	1
000.8-42-2-R	42646	2	6
000.8-42-8-L	42724	1	3
000.8-42-10-L	43016	2	15
000.8-42-10-R	42591	1	7
000.8-42-16-R	42325	1	5
000.8-42-24-R	43064	2	5
000.8-42-40-L	42634	2	16
000.8-42-40-R	42608	2	1
000.8-42-50-R	42839	1	2
000.8-42-72-R	42965	2	3
000.8-42-100-L	42605	2	16
000.8-60-4-L	41835	1	8
000.8-60-6-L	42107	2	3
000.8-60-8-R	42280	2	10
000.8-60-10-L	42782	2	11
000.8-60-16-R	41997	3	3
000.8-60-24-L	41813	4	1

Re: If row value changes

swuehl — Mon, 18 Jun 2012 14:27:25 GMT

Maybe adding to your script:

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

Re: If row value changes

Mon, 18 Jun 2012 15:12:24 GMT

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

MfG

Urdru

topic Re: If row value changes in QlikView

If row value changes

Re: If row value changes

Re: If row value changes