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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to match a different row names into unique names in QlikView

Hi Friends any quick help on of the below Problem:

I have a Dimension Quantity which has certain data as A,B,C,D..

A=A-XYZ(Here A & A-XYZ are same need to display as A)

N=NO(Here N &NO are same need to display single row as N)

And Finally need to group values of #N/A,N,None as NO Score?

How we can achieve this in QlikView please do needful?

Quantity
A
A-XYX
B
C
D
N
NO
#N/A
None
5 Replies
awhitfield
Partner - Champion
Partner - Champion

LOAD
Distinct(Left(Quantity,1)) as Quantity

stigchel
Partner - Master
Partner - Master

Hi,

In the load script you can use a mapping load first which you can then apply to your field quantity e.g.

MyMap:

mapping load * inline [From,To

'#N/A','NO'

'None','NO'

'N','NO'

];

Load.....

...

Applymap('MyMap', Quantity,Quantity) as Quantity,

....

From....

jyothish8807
Master II
Master II

Hi,

Try this:

Tab1:

LOAD * INLINE [

    Quantity

    A

    A-XYX

    B

    C

    D

    N

    NO

    #N/A

    None

];

Tab2:

lOAD *,

replace(replace(Quantity,'A-XYX','A'),'NO','N') as QuantityN

resident Tab1;

drop Table Tab1;

Regards

KC

Best Regards,
KC
maxgro
MVP
MVP

load

  Quantity,

  pick(wildmatch(Quantity, '#N/A', 'N', 'None', 'A', '*'),   'NO', 'NO', 'NO', 'A-XYZ', Quantity) as NewQuantity   

inline [

Quantity

A

A-XYX

B

C

D

N

NO

#N/A

None

];

stigchel
Partner - Master
Partner - Master

Has this answered your question? If so, can you please close this thread by marking one of the answers correct? It will help others find a (correct) answer to similar problems and lets other contributing members know that this requires no more attention.