topic conditional dimension in QlikView

conditional dimension

Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

i have a dimension called Branchcode. it has the following values

Branchcode:

0001,

0002,

....

0501,

0601,

OP01,

DP02,

DP04,

CD03,

RF01, etc...

i have to use this dimension where it excludes 0501, 0601, code with text.

but it should have the codes that start with 'DP' . how can i do this.

i tried like this.

if(not Match(Branchcode,'0501','0601','0701')AND IsNum(Branchcode) and not match(left(Branchcode,2),'DP'), Branchcode)

but it is giving nulls.

Please help

Re: conditional dimension

MK_QSL — Thu, 12 May 2016 08:08:05 GMT

What's issue in using only below one?

Where not Match(Branchcode,'0501','0601','0701')

Re: conditional dimension

Thu, 12 May 2016 08:11:28 GMT

no problem in that part.

if(not Match(Branchcode,'0501','0601','0701')AND IsNum(Branchcode) and

not match(left(Branchcode,2),'DP'), Branchcode)

the part highlighted in red is not working.

Re: conditional dimension

sunny_talwar — Thu, 12 May 2016 08:12:00 GMT

May be this:

If(not Match(Branchcode,'0501','0601','0701') and IsNum(Branchcode) or Wildmatch(Branchcode, '*DP*'), Branchcode)

Re: conditional dimension

Thu, 12 May 2016 08:22:17 GMT

i tried this,

it is giving values for the first two part but not 'DP'

Re: conditional dimension

MK_QSL — Thu, 12 May 2016 08:27:49 GMT

Where (Not Match(Branchcode,'0501','0601','0701') and IsNum(Branchcode)) or WildMatch(Branchcode,'DP*')

Re: conditional dimension

sunny_talwar — Thu, 12 May 2016 08:29:15 GMT

Check this out:

Table:

LOAD *,

If(not Match(Branchcode,'0501','0601','0701') and IsNum(Branchcode) or Wildmatch(Branchcode, '*DP*'), Branchcode) as BranchcodeNew;

LOAD * Inline [

Branchcode

0001,

0002,

0501,

0601,

OP01,

DP02,

DP04,

CD03,

RF01

];

Re: conditional dimension

Thu, 12 May 2016 12:12:05 GMT

its working sunny.

thanks a lot.

Re: conditional dimension

Thu, 12 May 2016 12:12:30 GMT

thank you so much manish