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: 
msbhuvanesh003
Contributor III
Contributor III

Merging Fields (or) Create the Dimension

Dear Expert,

Platform: Qlik Sense

i have a table shown in below.

In that table having 4 different delivery modes. i want to merge the particular delivery mode in a single column.

Like CP+XD+XT = Mode 1 ; XM= Mode 2.

if it’s possible to create the dimension means kindly share the steps.

Dimension 1 = Mode 1

Dimension 2 = Mode 2

Actual Data:

 

Deli.ModeTotal Count
CP383911
XD11970
XM1591480
XT1921940
Grand Total3909301

Condition:

 

CP+XD+XTMode1
XMMode2

Output Need Like Below:

 

Deli.ModeTotal Count
Mode12317821
Mode21591480
Grand Total3909301
1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

IF(Match(Deli.Mode,'CP','XD','XT'),'Mode1','Mode2') as NewMode

Use above in script.

View solution in original post

5 Replies
MK_QSL
MVP
MVP

IF(Match(Deli.Mode,'CP','XD','XT'),'Mode1','Mode2') as NewMode

Use above in script.

msbhuvanesh003
Contributor III
Contributor III
Author

Dear Manish,

its working fine...

but #N/A data count is shown "16".

i dnt want the additional count....

msbhuvanesh003
Contributor III
Contributor III
Author

Capture.PNG

msbhuvanesh003
Contributor III
Contributor III
Author

Thank you so much....

MK_QSL
MVP
MVP

Untick show null values for newMode Column