Solved: Re: Multiple Values in GetCurrentField( Group) - Qlik Community

vikasmahajan · ‎2014-01-30

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

tresesco · ‎2014-01-30

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)

View solution in original post

maneshkhottcpl · ‎2014-01-30

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 · ‎2014-01-30

Try something like below

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

tresesco · ‎2014-01-30

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 · ‎2014-01-30

Thanks Everyone!!!

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

jagan · ‎2014-01-30

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.