Discussion Board for collaboration on QlikView Scripting.
Hi I have the following table:
I want to create the following indicators. I want the site counter to start over for each region and the person counter to start over for each site.
Go to Solution.
Try something like this:
AutoNumber(Region) as RegionNr,
AutoNumber(Region&Site,Region) as RegionSiteNr,
AutoNumber(Region&Site&Person, Region&Site) as RegionSitePersonNr,
recno() as ID
(html, codepage is 1252, embedded labels, table is @1);