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: 
Not applicable

Using Like function in Dimension

Hi All,

I have list of groups in my table which is having common sub-strings. I want to create graphs based on that sub-strings.

Example:

A_JIR_DEV

B_JIR_RED

A_CON_DEV

B_CON_RED

In my dimension, I am trying like "=if(group_name like '%_JIR_%' ,group_name)".

Thanks,

Arpit

1 Reply
maxgro
MVP
MVP

for this result

1.jpg

the script is

load

  field,

  SubField(field, '_', 2) as substr1,

  SubField(field, '_', 3) as substr2

inline [

field

A_JIR_DEV

B_JIR_RED

A_CON_DEV

B_CON_RED

];

if you don't want to modify the script, you can use subfield in a calculated dimension too