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)
![asd.png](/legacyfs/online/96545_asd.png)
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