Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ray123
Contributor II
Contributor II

How can I create one column, based on one-hot-encoding values?

Hi Community, 

I would like to create an extra column in the QlikSense data load editor, based on multiple other columns. 

As an example: 

Example_Table:

Load:

     ID

   Jan

   Feb

 March 

Sales

 

My data looks like this: 

ID     JAN     FEB     MARCH   Sales

1          1          0           0              100 

2          1          0           0                50

3          0          1           0                75

4          0          1           0                80

 

As you can see, 'Jan, Feb and March' are one-hot-encoded. I would like to group them into one column, like this: 

ID     Month    Sales

1          JAN       100

2          JAN         50

3          FEB         75 

4          FEB         80

 

Many thanks in advance. 

 

 

1 Solution

Accepted Solutions
twanqlik
Creator
Creator

1 Reply
twanqlik
Creator
Creator