Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Valued Contributor

How to Find missing numbers from any series of data into Table box ?

Hi All ,

How to capture missing numbers from Any series data in a Straight Table Dynamically ?

Also It should have two input box to accept starting Range and End range  to narrow down search based on user fed range


Missing.PNG

Thanks & Regards

Shekar

1 Solution

Accepted Solutions
Highlighted

Re: How to Find missing numbers from any series of data into Table box ?

Another way with little manipulation in the script

View solution in original post

4 Replies
Highlighted
Partner
Partner

Re: How to Find missing numbers from any series of data into Table box ?

Hi

Have a look at the attach example

i think it does what you want

Highlighted

Re: How to Find missing numbers from any series of data into Table box ?

Another way with little manipulation in the script

View solution in original post

Highlighted
Valued Contributor

Re: How to Find missing numbers from any series of data into Table box ?

Sunny Bhai .. sunday and Still Not Out

Highlighted
Valued Contributor

Re: How to Find missing numbers from any series of data into Table box ?

Thank You Liron