Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create new table, based on where fields does not equal

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!

1 Reply
Anil_Babu_Samineni

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;

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)