Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
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