topic Need to get number in QlikView

Need to get number

bharatkishore — Fri, 10 May 2013 06:53:56 GMT

Dear Member,

I have a list box called "alplabets" in that i have sample data like

Now my requirement is if we if take this list box i need to get number like

A 1

B 1

C 1

D 1

Please help me on this.

Thanks and Regards,

R. Bharat Kishore

Re: Need to get number

swuehl — Fri, 10 May 2013 06:55:42 GMT

It may be enough to check 'Show frequency' option in general tab of list box properties.

If not, please specify how you determine 'number'.

Re: Need to get number

alexandros17 — Fri, 10 May 2013 06:56:56 GMT

What do you need?

A string "A 1" or two columns A and 1 or what else?

Re: Need to get number

bharatkishore — Fri, 10 May 2013 07:02:18 GMT

Thanks a lot...I just forget....

Re: Need to get number

bharatkishore — Fri, 10 May 2013 07:06:48 GMT

Now say that in that list box i have

Is it possible to get like

A 1

B 2

C 3

D 4

The number should be increasing if the alphabet gets added... Can you please help me on this.

I want result like

A 1

B 2

C 3

D 4

E 5

Thanks and Regards,

R. Bharat Kishore

Re: Need to get number

Fri, 10 May 2013 07:11:17 GMT

Hi Bharat.

The forum has quite a bit of information and if you take the time to look you will find the right solution for you. Effort is half the battle on the road to enlightenment

Cheers,

Byron

Re: Need to get number

Fri, 10 May 2013 07:19:09 GMT

If u need in the same sequence wht u stated, Use autogenerate

Re: Need to get number

bharatkishore — Fri, 10 May 2013 07:33:24 GMT

Thanks Bryan..Because of urgency i just forget it...Please don't mind...