topic Re: Categorize columns with the column name, and create a table. in QlikView

Categorize columns with the column name, and create a table.

gizzel123 — Tue, 23 Dec 2014 11:30:57 GMT

Hi all ,

I have columns from database as names: eg sales_1,sales_2, sales_3......cust_1,cust_2,cust_2.

Header 1	Header 2	Header 3	Header 4
category	1	2	3
sales	value	value	value
cust	value	value	value

how can i do that, please suggest.

its very urgent for me.

thanks in advance.

Gysbert_Wassenaar — Tue, 23 Dec 2014 11:51:34 GMT

You probably need to use the crosstable function in the script. Can you post an example source file?

Tue, 23 Dec 2014 12:11:37 GMT

PLZ post your sample data file.

thanks

S Shrivas

amit_saini — Tue, 23 Dec 2014 12:14:39 GMT

Hi,

Yes as Gysbert suggested cross table work here:

Thanks,
AS

gizzel123 — Tue, 23 Dec 2014 12:21:09 GMT

table:

col1,

col2,

col3....,

sales_asco,

sales_cmr,

sales_cq,

...,

cust_asco,

cust_cmr,

cust_cq.
this is the table...

now i have to extract the "cust , sales,...." as category....(not the first 41 columns) and again ASCO,CMR,CQ as the filed names in qlikview .

gizzel123 — Tue, 23 Dec 2014 12:22:46 GMT

Sorry guys i cant post the data i m using.