Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

Multiple Values in GetCurrentField( Group)

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.
1 Solution

Accepted Solutions
tresesco
MVP
MVP

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

5 Replies
maneshkhottcpl
Partner - Creator III
Partner - Creator III

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

Try something like below


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

tresesco
MVP
MVP

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
Author

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
Luminary Alumni
Luminary Alumni

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.