Discussion Board for collaboration on QlikView Scripting.
I need to mark each record based on CID, New_Site and Weekingdate.
CID contains unique data, New_Site and Weekending are not.
This is the data set in am loading and i need to mark each CID with the rolling number so example
Autonumber(CID, New_Site) as RollingNo
View solution in original post
It worked perfect. i changed it to
Autonumber( CID,New_Site& Weekending) as RollingNo
and i now see the grouping
as it created and group for every 50 records.
thank you for all your help.