Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

Re: logical operator

Try like:

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

Highlighted

Re: logical operator

Try this,

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

Highlighted
Creator
Creator

Re: logical operator

Thats correct. Thanks

Highlighted
Creator
Creator

Re: logical operator

Correct answer.

Thanks