Create new table, based on where fields does not equal

Wed, 25 Nov 2020 16:16:04 GMT

Hi all.

I have an excel doc with Case#, Category, and Subcategory. (Note that there is always a case number, but not always a category/subcategory). Data is attached.

I need to create another table in QlikView, let's call it Real_Category.

So if category = 'interfaces' and subcategory does not = 'cascade' or 'test123', then I want to create a field in Real_Category called 'Millwork'.

I would like a script solution. I currently have script for when it does equal something, but I would like solution for when it doesn't equal something.

Any help is appreciated, thank you!

Re: Create new table, based on where fields does not equal

Anil_Babu_Samineni — Mon, 03 Jul 2017 15:54:56 GMT

I haven't see even your excel. May be try this?

Load Category,

Subcategory,

Real_Category,

If(Category = 'interfaces', (If(Not WildMatch(Subcategory, 'cascade', 'test123'), Real_Category), 'Millwork')

From Table;

topic Re: Create new table, based on where fields does not equal in QlikView

Create new table, based on where fields does not equal

Re: Create new table, based on where fields does not equal