topic If condition in QlikView

If condition

Anonymous — Fri, 14 Apr 2017 16:30:43 GMT

Hi all,

One more question in writing a If condition!!

I am trying to filter data using if condition where I need to compare two fields. For example:

Let the fields be

1.Flag: which has only 1 and 0 value in it.

2. Name: This field has data something like this

Name

abc

bcd

rfg

3. Cname

4. Num : This field has data something like this :

Num

1234557

4567869

7864325

abc_123

bcd_567

rfg_675.

Note :Starting of some data in Num field resembles the data in Name. For example

Name Num

abc abc_123

bcd bcd_567

rfg rfg_675.

I need to bucket in the data for a field called "room" for a condition

Flag =1 or

Num = only that data which Starts with Name field.( Example = abc_123, bcd_567, rfg_675).

So expression should be like

If( Flag ='1' or Num = ' Like Name', Name, Cname) as room.

I hope I have explained in a simple way. Thank you.

Regards,

Re: If condition

krishnacbe — Fri, 14 Apr 2017 16:40:40 GMT

Hi,

Try below script.

if( Flag=1 or WildMatch(Num, '*' & Name & '*', Name, Cname) as room

Re: If condition

krishnacbe — Fri, 14 Apr 2017 16:42:23 GMT

There was a Typo. Please use below expression

if( Flag=1 or WildMatch(Num, '*' & Name & '*'), Name, Cname) as room

Re: If condition

Anil_Babu_Samineni — Fri, 14 Apr 2017 17:06:09 GMT

May be use this If( Flag =1 or Num like Name, Name, Cname) as room

Re: If condition

Anonymous — Fri, 14 Apr 2017 18:39:48 GMT

Hi Krishnapriya,

Thanks for the reply, I am getting the data when the condition is true but this time it's not bucketing the data if condition is false. That means the values for Cname are not populating.

Re: If condition

krishnacbe — Fri, 14 Apr 2017 19:05:43 GMT

I have verified with sample data, both true and false case is working fine.

Please find attached sample.

share me the false condition which is failing.

Re: If condition

Anonymous — Mon, 01 May 2017 16:00:43 GMT

Thank you Krishnapriya, it's working.

Re: If condition

krishnacbe — Mon, 01 May 2017 18:13:13 GMT

Great. Please mark the correct answer and close the thread.