topic Re: Exclude value from a dimension in QlikView

Exclude value from a dimension

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

Hi,

I have the dimension Supplier PO and it has values e.g. 123563P, RA-12345-0134

I want to exclude all the RA values from the dimension. I tried the following as a calculated dimension, but it does not seem to work.

=If(not Match([Supplier PO], 'RA*'), [Supplier PO])

Any ideas?

Thanks

Shamit

tamilarasu — Thu, 07 Jul 2016 06:22:26 GMT

Hi Shamit,

Try like,

If(Not WildMatch([Supplier PO], 'RA*'), [Supplier PO])

If( Not [Supplier PO] Like 'RA*' , [Supplier PO])

shamitshah — Thu, 07 Jul 2016 06:28:42 GMT

Thanks Tamil,

That worked.

Shamit

MindaugasBacius — Thu, 07 Jul 2016 06:28:42 GMT

=If(Index([Supplier PO], 'RA') = 0, [Supplier PO])

Result: