Merging Fields (or) Create the Dimension

[msbhuvanesh003]

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.Mode	Total Count
CP	383911
XD	11970
XM	1591480
XT	1921940
Grand Total	3909301

Condition:

CP+XD+XT	Mode1
XM	Mode2

Output Need Like Below:

Deli.Mode	Total Count
Mode1	2317821
Mode2	1591480
Grand Total	3909301

[MK_QSL · Accepted solution]

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

Use above in script.

[msbhuvanesh003]

Dear Manish,

its working fine...

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

i dnt want the additional count....

[msbhuvanesh003]

[msbhuvanesh003]

Thank you so much....

[MK_QSL]

Untick show null values for newMode Column