topic running number in qlikview script in QlikView

running number in qlikview script

Mon, 14 Sep 2009 11:16:11 GMT

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!

AW:running number in qlikview script

biester — Mon, 14 Sep 2009 12:11:57 GMT

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

running number in qlikview script

spsrk_84 — Mon, 14 Sep 2009 12:36:07 GMT

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

running number in qlikview script

spsrk_84 — Mon, 14 Sep 2009 12:39:38 GMT

sorry i forgot to attach the file .