topic Calculated Dimension in QlikView

Calculated Dimension

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys

I am trying to create a calculated dimension that only looks at invoice numbers that aren't 8 digits in length and begin with the number 5.

I have the following but it doesn't work, there is an error with the "-=" operator. Do any of you clever folks have any suggestions how I can amend this to work?

IF(LEN([Invoice Number] -= "8" AND WildMatch([Invoice Number],'5*'),'Barcoded',)

Many thanks,

Gareth

Re: Calculated Dimension

Anonymous — Tue, 10 Oct 2017 07:45:07 GMT

try this (only = instead of -=)

IF(LEN([Invoice Number] = "8" AND WildMatch([Invoice Number],'5*'),'Barcoded',)

Re: Calculated Dimension

devarasu07 — Tue, 10 Oct 2017 07:46:50 GMT

Hi,

Try like this, if it's not working would be able to share your mock data and expected results tks

IF(LEN([Invoice Number]<>8 AND WildMatch([Invoice Number],'5*'),Barcoded)

aggr(IF(LEN([Invoice Number]<>8 AND WildMatch([Invoice Number],'5*'),Barcoded),Barcoded)

Thanks,Deva

Re: Calculated Dimension

prieper — Tue, 10 Oct 2017 07:46:55 GMT

IF(LEN([Invoice Number] <> 8 AND WildMatch([Invoice Number],'5*'),'Barcoded')

edit: Typo

Re: Calculated Dimension

Anonymous — Tue, 10 Oct 2017 07:47:16 GMT

<> 8 for sure

Re: Calculated Dimension

tresB — Tue, 10 Oct 2017 07:50:06 GMT

OR like:

IF( Not LEN([Invoice Number] = 8 AND WildMatch([Invoice Number],'5*'),'Barcoded')

Re: Calculated Dimension

Anonymous — Tue, 10 Oct 2017 07:52:32 GMT

Thanks all