topic Re: logical operator in QlikView

logical operator

engr_farhanqadr — Tue, 10 Jul 2018 06:34:44 GMT

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

tresB — Tue, 10 Jul 2018 06:41:30 GMT

Try like:

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

tamilarasu — Tue, 10 Jul 2018 06:41:53 GMT

Try this,

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

engr_farhanqadr — Tue, 10 Jul 2018 07:07:22 GMT

Thats correct. Thanks

engr_farhanqadr — Tue, 10 Jul 2018 07:07:49 GMT

Correct answer.

Thanks