Rowno() count

[qlikview979]

Hi Experts,

PFA,

Here i want exclude the  blanks count .

Partner_Name	Inward_no &' -- '&RowNo()
A	16MS2ADHC7838 -- 1
B	16MS3SOS34969 -- 2
C	16MS3SOS36890 -- 3
D	-- 4
E	-- 5
F	16MS3SOS48772 -- 6
G	16MS3TRB37584 -- 7
H	16MS3TRB40266 -- 8
I	16MS4ADHC6867 -- 9
J	16MS4ADHC6902 -- 10
K	16MS4ADHC6951 -- 11
L	16MS4ADHC7835 -- 12
M	16MS4ADHC7842 -- 13
N	16MS4DEM48171 -- 14
O	16MS4PPNC7830 -- 15
P	16MS4SOS40478 -- 16
Q	16MS4SOS40871 -- 17
R	16MS4SOS43214 -- 18
S	-- 19
T	-- 20
U	-- 21
V	-- 22
W	16MS4SOS46341 -- 23
X	16MS4SOS46500 -- 24
Y	16MS4SOS46501 -- 25
Z	16MS4SOS46502 -- 26

Expected output:-

Partner_Name	Inward_no &' -- '&RowNo()
A	16MS2ADHC7838 -- 1
B	16MS3SOS34969 -- 2
C	16MS3SOS36890 -- 3
D
E
F	16MS3SOS48772 -- 4
G	16MS3TRB37584 -- 5
H	16MS3TRB40266 -- 6
I	16MS4ADHC6867 -- 7
J	16MS4ADHC6902 -- 8
K	16MS4ADHC6951 -- 9
L	16MS4ADHC7835 -- 10
M	16MS4ADHC7842 -- 11
N	16MS4DEM48171 -- 12
O	16MS4PPNC7830 -- 13
P	16MS4SOS40478 -- 14
Q	16MS4SOS40871 -- 15
R	16MS4SOS43214 -- 16
S
T
U
V
W	16MS4SOS46341 -- 17
X	16MS4SOS46500 -- 18
Y	16MS4SOS46501 -- 19
Z	16MS4SOS46502 -- 20

Regards

Mahesh

[qlikview979]

Hi Experts,

Help me on this

jagan‌loveisfail‌avinashelite‌vinieme12stalwar1‌

Regards

Mahesh

[Anil_Babu_Samineni]

May be like below

LOAD If(Len(Inward_no)>0,Inward_no &' -- '&RowNo(),' ') as Inward_no,

          Partner_Name

FROM

[Req.xlsx]

(ooxml, embedded labels, table is Sheet1);

[prat1507]

Hi Mahesh

Please use

T1:

LOAD

RowNo() as Row,

if(Inward_no='','',Inward_no &' -- '&RowNo())  as Inward_no_RowNo,

     Partner_Name

FROM

(ooxml, embedded labels, table is Sheet2);

[qlikview979]

Not working Anil

I want to calculate in front end

Regards

[qlikview979]

Hi Pratyush,

Not working.

Regrds

[avinashelite]

Try like this

LOAD if(len(trim(Inward_no))>0,Inward_no&'-'&AutoNumber(Inward_no)) as Row,

     Partner_Name

FROM

[My Documents\Req.xlsx]

(ooxml, embedded labels, table is Sheet1);

[prat1507]

Hi Mahesh

PFA the app with the desired results.

Regards
Pratyush

[avinashelite]

[qlikview979]

Hi All,

Here i am attaching Original   IP/OP and QVW,

I want calculate in Front end level

Regards

Mahesh