topic Re: Auto Numbering in Text Object in QlikView

Auto Numbering in Text Object

santhoo_san — Fri, 22 Feb 2013 10:50:09 GMT

Hi,

I have a tex Object with multiple project names. I want to put auto serial number for project names withing the text object. Can anyone help me in solving this. I am attaching a sample file for quick reference.

Regards,

Santhosh

Re: Auto Numbering in Text Object

flipside — Fri, 22 Feb 2013 11:12:29 GMT

Hi Santosh,

It might be easier to use a straight table chart with Project Name as the Dimension and RowNo() as the Expression, then just drag the Expression to the left of the dimension and format the table without totals, headers etc..

flipside

EDIT: Which I see you have already done - ignore this!

Re: Auto Numbering in Text Object

flipside — Fri, 22 Feb 2013 11:38:40 GMT

The closest I have got is ...

=concat(distinct FieldIndex('Project Name',[Project Name]) & ' ' &[Project Name],'

',FieldIndex('Project Name',[Project Name]))

... but this will be the order the data is loaded, not alphabetical unless you sort this in the script. Also the numeric value is fixed against the location (not sure if this is what you needed).

flipside

Re: Auto Numbering in Text Object

Fri, 22 Feb 2013 11:42:06 GMT

Hi,

Check the attachment.It may help you.

Regards

Kumar

Re: Auto Numbering in Text Object

santhoo_san — Fri, 22 Feb 2013 11:50:58 GMT

Hi flipside,

Thank you....

Regards,

Santhosh

Re: Auto Numbering in Text Object

santhoo_san — Fri, 22 Feb 2013 12:11:29 GMT

Hi flipside,

Can we use set analysis for Project Name to filter the project names based on some criteria in the solution provided?

=concat(distinct FieldIndex('Project Name',[Project Name]) & ' ' &

[Project Name] // want to filter this field

',FieldIndex('Project Name',[Project Name]))

Regards,

Santhosh

Re: Auto Numbering in Text Object

flipside — Fri, 22 Feb 2013 12:41:14 GMT

Yes, you can use SA with the concat function, such as ...

=concat({<[Project Name]={'B*','K*'}>} distinct FieldIndex('Project Name',[Project Name]) & ' ' &[Project Name],'

',FieldIndex('Project Name',[Project Name]))

... to return only names beginning B or K, for example.

Re: Auto Numbering in Text Object

flipside — Fri, 22 Feb 2013 12:54:07 GMT

For a slightly different result, where the Project Name numbering ISN'T fixed, and will change based on selections, you can create a variable (named Projects2 in my example) as this ...

=';' & concat([Project Name],';')

... then when building the text string for the text object, count the number of delimiters (';' in my example) prior to the field in the variable list to identify its position ...

=concat(SubstringCount(Subfield(Projects2,[Project Name],1),';') & ' ' & [Project Name],chr(10), SubstringCount(Subfield(Projects2,[Project Name],1),';'))

flipside