topic Grouping/categorizing columns within script in QlikView

Grouping/categorizing columns within script

Thu, 16 May 2013 09:56:18 GMT

Hello community,

on the left side in the image you can see my Excel file. The database table is the same except that I don't have the "Category 1", "Category 2" column headers.
I want to group these using Qlikview - see the small table on the right. So that I can select Category 1 and I only get Col1 to Col3 values.

Can I group the different colums in the load stmt? Do I need to transform the colums to field values.

Hope you can help me out here.

Thank you.

Re: Grouping/categorizing columns within script

Gysbert_Wassenaar — Thu, 16 May 2013 10:23:39 GMT

You can use the crosstable function to load the data and create another table for the categories. You may have to change the headers in the excel file so that all the headers are on the same row, i.e. moving Plant, Year and Month a row down instead of using merged cells.

Table1:

Crosstable(Col, Value,3)

load Plant, Year, Month, Col1,Col2,Col3,Col4,Col5,Col6

from ...myexcelfile...;

Table2:

Load * inline [

Category, Col

Category1,Col1

Category1,Col2

Category1,Col3

Category2,Col4

Category2,Col5

Category2,Col6

];

Re: Grouping/categorizing columns within script

Thu, 16 May 2013 10:47:15 GMT

thanks for your reply. Notice that I don't use the Excel file within QlikView. I'm using a database table but without the Category headers.

I only need these Category names for grouping.

Check out the attached sample.