Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
aatish12345
Creator II
Creator II

grouping of Values from same field

Hi all, I have a field "city", which has below data

City

A

B

C

D

Now I want to group C and D and need to show as C (which actually will be the combination of C and D) in the same city field. The below output I am expecting

City

A

B

C

C is actually a combination of C and D

Can anyone please help me to achieve this

 

Aatish

 

 

 

 

Labels (1)
1 Reply
Or
MVP
MVP

Load If(City = 'D','C',City) as City

From YourTable;