Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Converting Table Columns in to Rows

Hi All,

I am trying to generate a report and have an App in QlikSense generating a table from a qvd files from our database.

I have a column that pulls particulars of data from the database and another column that pulls its corresponding Value. The problem occurs when I want to have only a few or multiple child data to be generated. As the first column pulls particulars of data (approximately 20+ different types) thereby, creating 20+ different repetitions of the same case in 20+ rows.

Is it possible to rather have this data presented in columns instead? And perhaps even being able to only select specific particulars to have only their corresponding values being generated in columns.

The final aim is to produce an excel sheet from this data..import it to an Access database and generate a specific structure of a report.

Here's a sample of what I am facing now.

Client NameCodenameCode Value
John DoeIDnumber123456
John DoecommentsTest comment

John Doe

contact personBob
John DoeInvoice number 987654
John Doeservice typetype 1

I hope the above gives you the drift of my question. Firstly I do not want the table to repeat the client name in multiple rows and secondly, get the code names and their respective values in separate columns.

Any help of suggestions will be much appreciated.

5 Replies

Re: Converting Table Columns in to Rows

See this blog post: The Generic Load


talk is cheap, supply exceeds demand
Not applicable

Re: Converting Table Columns in to Rows

Thank you.

But I am not good with coding. Also this seems a post for Qlik View. Will it also apply to Qlik Sense? My request is for a table in Qlik Sense.

Re: Converting Table Columns in to Rows

Script functions used in QlikView are usable and can be ported over to Qlik Sense so you should be good with that.

Re: Converting Table Columns in to Rows

Script:

Generic

LOAD

    "Client Name",

    Codename,

    "Code Value"

FROM [lib://Lib]

(html, codepage is 1252, embedded labels, table is @1);

Output:

Capture.PNG

Not applicable

Re: Converting Table Columns in to Rows

That sounds great!

Will test it and let you know.

Thank you.

Community Browser