Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rosariogonzalez
Contributor
Contributor

Reclassify column data

I am trying to reclassify the data in a column to make a new pivot table.

The column is called a product grouper and has several classifications: health, beauty, beverages ... etc. What I need is to change the classification, for example to health to put remedies, beauty to put makeup on it, drinkable beverages etc.

I am just learning how to use QV but it occurred to me to use if as follows:

= if (product_grouper = 'health', 'remedies', if (product_grouper = 'beauty', 'makeup', drinks))

The problem is that, on the one hand, it doesn't work for me and, on the other hand, there are 33 classifications and it would be impossible to do it so many times.

Is there an easier way to do it?

0 Replies