topic Re: If And Statement in QlikView

If And Statement

Tue, 19 Sep 2017 16:51:12 GMT

I am struggling in writing an if and statent in qlikview. I am used to doing it in sql but it's different.

I want to say

If field1 = 'yes' and field2 = 'yes' then 'match' or

If field1 = 'yes and field2 = 'no' then 'match1' or

If field1 ='no and field2 = 'yes' then 'match2'

Else 'no match'

Is this possible in qlikview.

I have tried using match and wild match but don't seem to get the and and or working

Re: If And Statement

sunny_talwar — Tue, 19 Sep 2017 16:53:56 GMT

May be this

If(field1 = 'yes',

If(field2 = 'yes', 'match', 'match1),

If(field2 = 'yes', 'match2', 'no match')) as MatchFlag

Re: If And Statement

Anil_Babu_Samineni — Tue, 19 Sep 2017 16:55:45 GMT

With in Qlik we can achieve anything.. Perhaps this?

If(field1 = 'yes', If(field2 = 'yes', 'match', 'match1), If(field2 = 'yes', 'match2', 'no match'))

If(field1 = 'yes' and field2 = 'yes', 'match', If(field1 = 'yes' and field2 = 'no', 'match1', If(field1 ='no' and field2 = 'yes', 'match2', 'no match')))

Re: If And Statement

its_anandrjs — Tue, 19 Sep 2017 17:12:49 GMT

Try this may be matches with your requirement

if(field1 = 'yes' and field2 = 'yes', 'Match',

if(field1 = 'yes' and field2 = 'no','Match1',

if(field1 = 'no' and field2 = 'yes','Match2'))) as logicField

Re: If And Statement

svinnakota — Tue, 19 Sep 2017 17:21:27 GMT

Hi Sarah,

If condition in qlik is similar to case condition in SQL. Just compare the below syntax with case condition. The code is for the script level.

case when field1 = 'yes' and field2 = 'yes' then 'match'

when field1 = 'yes and field2 = 'no' then 'match1'

when field1 ='no and field2 = 'yes' then 'match2'

Else 'no match' end in SQL

In Qlik instead of when we will keep ","(commas)

If (field1 = 'yes' and field2 = 'yes' , 'match' , ------- case when field1 = 'yes and field2 = 'yes' then 'match' when

If( field1 = 'yes and field2 = 'no' , 'match1' , ---------- field1= 'yes' and field2 ='no' then 'match1' when

If (field1 ='no and field2 = 'yes' ,'match2', -------------- field1 ='no and field2 = 'yes' then 'match2' else

'no match' ))) 'no match' end

Make sure all the open braces are closed.

Re: If And Statement

its_anandrjs — Tue, 19 Sep 2017 17:31:23 GMT

Hi Sarah,

You can do this on the loading script or else UI part on the Qlikview.

On Load Script

Load

if(field1 = 'yes' and field2 = 'yes', 'Match',

if(field1 = 'yes' and field2 = 'no', 'Match1',

if(field1 = 'no' and field2 = 'yes', 'Match2','no match'))) as logicField

From Source;

On Ui part you can use but perhaps you can select suppress when values is null() but care ully you have to do this.

On UI Part

if(field1 = 'yes' and field2 = 'yes', 'Match',

if(field1 = 'yes' and field2 = 'no', 'Match1',

if(field1 = 'no' and field2 = 'yes', 'Match2','no match')))

Note:- If result not matched you can go for the multiple Preceding load or Concatenation between loads or tables

Find the attached Manual from Qlik Help

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptControlStatements/If.htm