Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
engr_farhanqadr
Creator
Creator

logical operator

Dear Folks,

I am trying to write logic where I need to multiply a Column with 0.4 when quarter Q1 and Q2 both selected. but I am failed to do so

if ( GetFieldSelections(Quarter) = 'Q1' and GetFieldSelections(Quarter) = 'Q2' , Column * 0.4)


please guide.


Thanks

4 Replies
tresesco
MVP
MVP

Try like:

if ( Index(GetFieldSelections(Quarter), 'Q1') and Index(GetFieldSelections(Quarter), 'Q2') , Column * 0.4)

tamilarasu
Champion
Champion

Try this,

If( Wildmatch(GetFieldSelections(Quarter),'Q1*Q2*'), Column * 0.4)

engr_farhanqadr
Creator
Creator
Author

Thats correct. Thanks

engr_farhanqadr
Creator
Creator
Author

Correct answer.

Thanks