creating a list of records from a table

[tinkerz1]

Hi can I take a table and turn it into a list??

Message was edited by: Neil Woodham

[swuehl]

You are talking about showing the data in a list in the frontend, right?

For a fixed number of records, you can use conditionally shown text objects, I've done something similar a while ago.

This will be not dynamic.

Maybe there is an extension available, though.

[qlikviewwizard]

Hi Tinkerz1

Can you attach the xls file?

[senpradip007]

Something like this!!

[swuehl]

Had same idea as Pradip, added some formatting.

[tinkerz1]

Sorry I am on the free download version, can you post a screen shot?

Many Thanks,

Neil.

[tinkerz1]

Sorry I am on the free download version, can you post a screen shot?

Many Thanks,

Neil.

[Chanty4u]

nice swuehl..

[senpradip007]

Try to use this in script.

CROSSTABLE (Field, Value)

LOAD recno() as ID, * INLINE [

RecordNo, Name, Adress

1, Brian, Brighton

2, Simon, Birmingham

3, Kent, London

4, Bob, Swindon

];

[swuehl · Accepted solution]

Basically transform your data set using CROSSTABLE LOAD:

CROSSTABLE (Field, Value)

LOAD

  recno() as ID,

  * ,

  ' ' as ' '

INLINE [

RecordNo, Name, Adress

1, Brian, Brighton

2, Simon, Birmingham

3, Kent, London

4, Bob, Swindon

];

Key to success is that you create a new ID (using recno() in this sample). I also added an empty field to separate grouped records in the frontend.

Then create a straight table, use ID, Field, Value as dimensions and

=1

as expression.

Sort ID asc, Field by Load order asc.

On presentation tab, hide columns for ID and expression.

You can also change labels, dimension attributes for some further visual enhancement.