topic Re: not match in QlikView

not match

Wed, 15 Mar 2017 05:47:59 GMT

Hi Guys,

I want to write a expression if Category matches Chair, Table then Furniture , if Category not matches Dummy then Other Items.

How to write this in qlikview script.

vinieme12 — Wed, 15 Mar 2017 05:55:06 GMT

using Wildmatch() or Match() function

example

if(Wildmatch(Category,'Chair','Table')>0,'Furniture','Dummy')

nitin_01 — Wed, 15 Mar 2017 06:00:38 GMT

Hi Roisha,

This might help you,

=if(Category='Chair' or Category='Table','Furniture',Other Items)

If(Match(Category,'Chair','Table'),'Furniture',Other Items)

Regards,

Nitin.

bhargav_bhat — Wed, 15 Mar 2017 06:51:45 GMT

Hi Roisha,

This might be the equation you are looking for

if(Category='Chair' or Category='Table','Furniture',if(Category-='Dummy','Other Items',Category))