running number in qlikview script

[#1]

hi all,

i want to create the following result just using script:

Tenant ShopName RunningNumber

ABC GAP 1

ABC PF Chang 2

ABC Topman 3

Season's Group Pte Ltd Bloomingdale's 1

Season's Group Pte Ltd Nike Apparel 2

Season's Group Pte Ltd McDonald's 3

The running number is by tenant and shops. i tried to use for loop and rowno() or autogenerate but couldn't get the result i needed.

Also, i'm having issue when i loop through each tenant i'll have issue with apostrophe for e.g. when the name is Season's Group Pte Ltd. My script is written like this:

where Tenant = '$(vTenant)';

Any idea? any help is appreaciated. thanks!

[biester]

As to the running number I'd suggest to use peek().

As to the apostrophe: I don't quite understand your problem. Could you perhaps post your script?

Rgds,
Joachim

[spsrk_84]

Hi,

I got one solution and i am attaching qv file go through the file i hope it will gives u the result u expected . IS it is possible for you to attach ur sample data file so that it willl help me to give the desired output.

Regards,

Ajay

[spsrk_84]

sorry i forgot to attach the file .