Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
LuisM
Contributor III
Contributor III

Group

Hi All

I have a data base with a Column Description of many products, those have description by color, but at the end are the same. Like photo i added:

LuisM_0-1655392176624.png

For example BLACK MATTE, ICED SILVER is the color but both are VS-S711H

Other example:

LuisM_1-1655392666341.png

the group should be C-3X-02-F.

So l want to know if is possible group them

 

Thank you all

 

Labels (1)
3 Replies
LuisM
Contributor III
Contributor III
Author

I want to do it in QLIK CLOUD for sure

 

Thanks

vinieme12
Champion III
Champion III

use subfield()

 

subfield(Producto,' - ',1) as productgroup

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
LuisM
Contributor III
Contributor III
Author

Hi Vinie!!

So  here ' - ' is where l must put product name?

I will try it because there are a lot of products that should be group.

My plot appears in this way and what l want is just have 1.

LuisM_0-1655490276070.png

Thank you! 

i will test with subfield