Multiple Values in GetCurrentField( Group)

[vikasmahajan]

Hi,

I used following expression to show conditional in chart using QV version 11, I want to give multiple values like product group

=IF(GetCurrentField(DBdQPTB)={'Product Group'},1,0)        like   { 'Product Group' ,'Brand','Therapy'}

How to use please explain.

Vikas

[maneshkhottcpl]

Hi

Use wildmatch

=IF(GetCurrentField(DBdQPTB)={'Product Group'},1,0)

like   { 'Product Group' ,'Brand','Therapy'}

IF(Wildmatch(GetCurrentField(DBdQPTB),'Product Group' ,'Brand','Therapy')>0,1,0)

Regards

Manesh

[MK_QSL]

Try something like below

=IF(CONCAT($(=GetCurrentField(DBdQPTB),',') = { 'Product Group' ,'Brand','Therapy'}, 1,0)

[tresesco · Accepted solution]

Not sure if understood right. Assuming you want  comparison like OR, then :

May be like:

IF( Match(GetCurrentField(DBdQPTB),'Product Group' ,'Brand','Therapy'),1,0)

[vikasmahajan]

Thanks Everyone!!!

[jagan]

Hi Vikas,

You can try using Match() like this

=IF( Match(GetCurrentField(DBdQPTB),'Product Group' ,'Brand','Therapy'),1,0)

Hope this helps you.

Regards,

Jagan.