Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
felcar2013
Partner - Creator III
Partner - Creator III

transforming "n" dimensions into 1

hi

i have 9 columns in a table containing more than 20 and i want to transform them into only one column, so that i can use the dimension (new created column) in a bar chart.

the columns (A1,A2,..., A9) have "1" or "null" as value. How can i transform this, so that i can get a dimension called A, with dimension values as A1, A2, ...., A9 and the expression calculated in a bar chart. it is not possible to transform when uploading data

thanks

1 Solution

Accepted Solutions
Gysbert_Wassenaar

This should work:

Table1:

Load ContactID, ColumnX, ColumnY, ColumnZ ...etc

from mysourcetable;

Table2:

Crosstable(NewA, Value)

Load ContactID, A1, A2, A3, A4, A5

from mysourcetable;


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
andrea_reyes
Contributor III
Contributor III

Hello,

Can you load the qvw? or You can give more information?

felcar2013
Partner - Creator III
Partner - Creator III
Author

contactID

A1A2A3A4Column X
111
21114
316
4114
513

6

1116
71112

hi Andrea and thanks for your time

I have a table like this (from an excel file), the columns i want to transform are {A1, A2,A3,A4,A5}, column x, is another column in the table, and there are more than 20 additional columns.

I want to create something like this. A table containing the contact id and a new dimension , like A, so that i can use it as dimension in a chart

thanks

felipe

ContactIDNew dimension "A"
1A1
2A2
2A3
2A4
3A4
4A1
4A3
5A3
6A1
6A2
6A3
7A2
7A3
7A4
Gysbert_Wassenaar

This should work:

Table1:

Load ContactID, ColumnX, ColumnY, ColumnZ ...etc

from mysourcetable;

Table2:

Crosstable(NewA, Value)

Load ContactID, A1, A2, A3, A4, A5

from mysourcetable;


talk is cheap, supply exceeds demand
felcar2013
Partner - Creator III
Partner - Creator III
Author

thanks, exactly what i needed