not match

[#1]

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]

using Wildmatch() or Match() function

example

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

[nitin_01]

Hi Roisha,

This might help you,

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

Or

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

Regards,

Nitin.

[bhargav_bhat]

Hi Roisha,

This might be the equation you are looking for

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