load rowno() script in SQL

Thu, 20 Aug 2015 10:35:07 GMT

Hi Everybody...

the trigger is my script in qlikview expression wont work becouse it dont have RowNo()

this is my script(i got this script from mr/mrs.settu in this community) :

if(RowNo()=1,

if(DEBET<1,

(LSALDO-OUTCOME),

(LSALDO+INCOME)),

if(INCOME<1,Rangesum(Above(Column(3)),-Sum(OUTCOME)),

Rangesum(Above(Column(3)),Sum(INCOME))))

and.. this is my qlikview table(with wrong values Rangesum)

i create RowNo in expression.. not in main script.

can i create LOAD RowNo() in main script with my SQL Database script

maybe its like :

Load RowNo(),

select * from username_table

where ..... = '......'

can anyone give me the correct load RowNo() script in SQL

topic load rowno() script in SQL in QlikView