help ti count the experience

Fri, 17 Oct 2014 12:28:47 GMT

Hello,

Could someone help me, please? I've got a table like

salary month	Object_ID	TOP_manager
01.01.2014	25	Thompson Eric
01.01.2014	36	Grundalf Mark
01.01.2014	48	Stowny Oliver
01.01.2014	52	Clinton Scott
01.02.2014	25	Thompson Eric
01.02.2014	36	Grundalf Mark
01.02.2014	48	Stowny Oliver
01.02.2014	52	Newman Peter
01.03.2014	25	Thompson Eric
01.03.2014	36	Tensley Tom
01.03.2014	48	Stowny Oliver
01.03.2014	52	Newman Peter
01.04.2014	25	Thompson Eric
01.04.2014	36	Tensley Tom
01.04.2014	48	Clarksson Edward
01.04.2014	52	Newman Peter

From this data I need to get the exsperience of each top, to be able to use if further in charts (the quality of work in the dependent of the exsperience). I've tried to make a temp table, to load and sort by TOP_manager, see if it's the the first entry of top in chart (top_manager<>previos(top_manager)),put the name of first month in a special added field then count months, but it doesn't help// tried to use lookup, peek.... just doesn't work right

I need to get something like

salary month	Object_ID	TOP_manager	Experience
01.01.2014	25	Thompson Eric	1
01.01.2014	36	Grundalf Mark	1
01.01.2014	48	Stowny Oliver	1
01.01.2014	52	Clinton Scott	1
01.02.2014	25	Thompson Eric	2
01.02.2014	36	Grundalf Mark	2
01.02.2014	48	Stowny Oliver	2
01.02.2014	52	Newman Peter	1
01.03.2014	25	Thompson Eric	3
01.03.2014	36	Tensley Tom	1
01.03.2014	48	Stowny Oliver	3
01.03.2014	52	Newman Peter	2
01.04.2014	25	Thompson Eric	4
01.04.2014	36	Tensley Tom	2
01.04.2014	48	Clarksson Edward	1
01.04.2014	52	Newman Peter	3

thanks in advance

Re: help ti count the experience

Gysbert_Wassenaar — Fri, 17 Oct 2014 12:40:06 GMT

Try: autonumber([salary month], TOP_manager) as Experience

Re: help ti count the experience

Fri, 17 Oct 2014 12:49:21 GMT

THANK YOU!!!!!! Thats really what I need

topic Re: help ti count the experience in QlikView

help ti count the experience

Re: help ti count the experience

Re: help ti count the experience