Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

=if(Match(Year_V, '2018') ,[Opportunity Name]) How to add one more condition ?

Hi All

I have below expression at dimension it work fine :-

=if(Match(Year_V,

'2018')

,[Opportunity Name])

I need to add one more condition , that is field name Probability > 0 :-

=if(Match

(Year_V,'2018'),

(Probability,'>0')

,[Opportunity Name])

=if(Match

(Year_V,'2018' Probability,'>0'),

[Opportunity Name])

But it fall to work , can some one advise me where i go wrong ?

Paul

1 Solution

Accepted Solutions

Re: =if(Match(Year_V, '2018') ,[Opportunity Name]) How to add one more condition ?

Try with

=if(Match(Year_V,'2018')>0 and Probability > 0,[Opportunity Name])

But I am not sure you need really this ... try to explain better.

Thanks

2 Replies

Re: =if(Match(Year_V, '2018') ,[Opportunity Name]) How to add one more condition ?

Try with

=if(Match(Year_V,'2018')>0 and Probability > 0,[Opportunity Name])

But I am not sure you need really this ... try to explain better.

Thanks

paulyeo11
Valued Contributor II

Re: =if(Match(Year_V, '2018') ,[Opportunity Name]) How to add one more condition ?

Hi Alessan

Thank you very much.

it work fine.

Paul

Community Browser