topic Re: Explanation in QlikView

Explanation

Thu, 22 Jan 2015 10:28:52 GMT

Hi Everybody ,

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

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

Re: Explanation

anbu1984 — Thu, 22 Jan 2015 10:33:10 GMT

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'

Re: Explanation

PrashantSangle — Thu, 22 Jan 2015 10:33:37 GMT

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

Re: Explanation

Thu, 22 Jan 2015 10:36:28 GMT

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'

Re: Explanation

avinashelite — Thu, 22 Jan 2015 10:38:14 GMT

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,

Re: Explanation

Anonymous — Thu, 22 Jan 2015 12:05:27 GMT

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

Re: Explanation

Thu, 29 Jan 2015 04:25:06 GMT

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