topic Re: identfiy missing numbers in a series in QlikView

identfiy missing numbers in a series

Thu, 29 Aug 2013 05:56:34 GMT

hi i have the following scenario

i load in a list of article numbers between a intervall 1-10.

is there anyway in Qlikview you can identify that the missing numbers in the series?

ie. 3, 5, 7,10

Best

Brad

tresB — Thu, 29 Aug 2013 06:02:28 GMT

Several ways would be there. You can try something like:

Load

YourData,

If(RowNo()<>YourData, RowNo()) as MissingData

From <> ;

You might have to add some offset value to Rowno()/RecNo() if the data is not starting with 1.

Thu, 29 Aug 2013 06:13:23 GMT

Thanks for the advice works great.

regarding offset.

for example with the value starting from 1001, how is the offset set in the script?

Best,

Brad

tresB — Thu, 29 Aug 2013 06:17:58 GMT

then try this:

Load

YourData,

If((RowNo()+1000)<>YourData, (RowNo()+1000)) as MissingData

From <> ;