Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

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
MVP
MVP

Re: Using Like function in Dimension

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

Community Browser