Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 Name | Codename | Code Value |
---|---|---|
John Doe | IDnumber | 123456 |
John Doe | comments | Test comment |
John Doe | contact person | Bob |
John Doe | Invoice number | 987654 |
John Doe | service type | type 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.
See this blog post: The Generic Load
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.
Script functions used in QlikView are usable and can be ported over to Qlik Sense so you should be good with that.
Script:
Generic
LOAD
"Client Name",
Codename,
"Code Value"
FROM [lib://Lib]
(html, codepage is 1252, embedded labels, table is @1);
Output:
That sounds great!
Will test it and let you know.
Thank you.