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

[Anil_Babu_Samineni]

I replied to avinash, Check that expression and let me know?

[qlikview979]

Hi Brother

Please check this two images

Qlikview Output

Desired output

[Anil_Babu_Samineni]

Before posting some thing, Please look at the repliers

if(aggr(Sum({<[VIN Number]=>}[Gross Amount]),[Partner Name])-aggr(Sum({<[VIN Number]=>}Deduction),[Partner Name])>0,

Serials&'-'& Aggr(RowNo(TOTAL), [Partner Name])&'\'&count( DISTINCT TOTAL [Partner Name]))

Here, Sasi has same . Could be helpful

[avinashelite]

Try like this

if(aggr(Sum({<[VIN Number]=>}[Gross Amount]),[Partner Name])-aggr(Sum({<[VIN Number]=>}Deduction),[Partner Name])>0,

Serials&'-'& aggr(RowNo(),[Partner Name]) &'\'&count( DISTINCT TOTAL [Partner Name]))

Oh sasi_k already give the solution .....

[qlikview979]

Thanks for All

Regards

Mahesh