Explanation

[#1]

Hi Everybody ,

Can someone please explain me what does the below expression do ?

if(WildMatch([WBS Element],'DEF*'),1,'Others')))

[anbu1984]

WildMatch([WBS Element],'DEF*') -- Check if [WBS Element] starts with DEF

if(WildMatch([WBS Element],'DEF*'),1,'Others'))) --  If [WBS Element] starts with DEF then return 1 else 'Others'

[PrashantSangle]

Hi,

It will give you if WBS Element field contain value started with DEF or def

the assign it as 1 else it will give you Others

Output like

if WBS Element

Value contain          Output    

DEF                             1

def                               1

defghh                         1

jjggj                         Others

defasd                         1

Regards

[#4]

it will give return  1 if the value in [WBS Element] starts from 'DEF' irrespective of case (Like defence, defend, def lappard etc) otherwise it will return 'Others'

[avinashelite]

Hi

It goes like this:

WildMatch([WBS Element],'DEF*')

output 1 or 0

first they are trying to find whether the [WBS Element] field has any value like 'DEF*' * indicates many no of occurrence

if(WildMatch([WBS Element],'DEF*') is true it will give 1 else 'others'

in second past they are using IF condition to get the result as 1 or other . if wildmatch over the filed is true it will give 1 as result and it will move to first part of if condition i.e.  1 if not it will give 'Others,

[Anonymous]

Hi Wrestler,

if(WildMatch([WBS Element],'DEF*'),1,'Others')))

The above expression is creating a flag using WildMatch function using if statement.

If [WBS Element] field is having values starting with DEF text it's assigning ,1 to the flag else others.

The WildMatch function performs a case insensitive comparison and permits the use of wildcard characters ( * and ?) in the comparison strings.

Hence you can check for text starting with 'DEF*' , 'def*' or any combination(Upper case/Lower case)

Regards

Neetha

[#7]

Thanks great explanation 

From: neetha P <qcwebmaster@qlikview.com>

To: the wrestler <zarrar_smile@yahoo.com>

Sent: Thursday, January 22, 2015 5:35 PM

Subject: Re: - Explanation

|

|

Explanation

reply from neetha P in New to QlikView - View the full discussionHi Wrestler, if(WildMatch(,'DEF*'),1,'Others')))The above expression is creating a flag using WildMatch function using if statement.If field is having values starting with DEF text it's assigning ,1 to the flag else others. The WildMatch function performs a case insensitive comparison and permits the use of wildcard characters ( * and ?) in the comparison strings.Hence you can check for text starting with 'DEF' , 'def' or any combination(Upper case/Lower case) RegardsNeetha

Reply to this message by replying to this email, or go to the message on Qlik Community

Start a new discussion in New to QlikView by email or at Qlik Community

© 1993-2014 QlikTech International AB | Copyright & Trademarks | Privacy | Terms of Use | Software EULA