"Like" function in Qlikview Dimension

[#1]

Hi,

How we can filter out results based on sub-string used in a dimension ?

Similar to what we use "like" in sql queries.

I am trying something like =if(group_name like '%_JIR_%',group_name)

Thanks,

Arpit

[Miguel_Angel_Baeyens]

Hi Arpit,

Use the WildMatch() function instead.

WildMatch('String', '*trin*')

Miguel

[#3]

What I should do if I want to remove last characters from values of one dimension and use it as another dimension ?

e.g. I have many values in this format "ABC_JIR_XYZ" as Dimension A. I want to remove all values after second '_ ' to get just "ABC_JIR" and term it as Dimension B and make all my reports on Dimension B.

[Miguel_Angel_Baeyens]

Then

=SubField('ABC_JIR_XYZ', '_', 1) & '_' & SubField('ABC_JIR_XYZ', '_', 2)

Miguel

[maxgro]

=left('ABC_JIR_XYZ', index( 'ABC_JIR_XYZ', '_', -1) -1)

[anbu1984]

You can use Like in qlikview. Use * instead of % in qlikview

if(group_name like '*_JIR_*',group_name)

[mukesh24]

u can use wildmatch() in qlikview