topic Re: Multiple Values in GetCurrentField( Group) in QlikView

Multiple Values in GetCurrentField( Group)

vikasmahajan — Thu, 30 Jan 2014 07:03:52 GMT

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 — Thu, 30 Jan 2014 07:06:46 GMT

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 — Thu, 30 Jan 2014 07:08:22 GMT

Try something like below

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

tresB — Thu, 30 Jan 2014 07:09:56 GMT

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 — Thu, 30 Jan 2014 07:13:19 GMT

Thanks Everyone!!!

jagan — Thu, 30 Jan 2014 07:18:51 GMT

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.