identfiy missing numbers in a series

[#1]

hi i have the following scenario

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

1

2

4

6

8

9

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

ie. 3, 5, 7,10

Best

Brad

[tresB · Accepted solution]

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.

[#3]

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]

then try this:

Load

          YourData,

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

From  <>  ;