Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
shamitshah
Partner - Creator
Partner - Creator

Exclude value from a dimension

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

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

Hi Shamit,

Try like,

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


OR


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

View solution in original post

3 Replies
tamilarasu
Champion
Champion

Hi Shamit,

Try like,

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


OR


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

shamitshah
Partner - Creator
Partner - Creator
Author

Thanks Tamil,

That worked.

Shamit

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

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

Result:

Screenshot_1.jpg