Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help require for Qlikview Scripting..!!

Hi All,

I have table like below:

ProductProduct CategoryClass
MaskFF123
PaperFF456
FoodFF789
CoffeeTT127

I need to add a Product Category as 'AA' so that every other new Product class which is not present in 'Class' will be considered in 'AA' category.

For example:

ProductProduct CategoryClass
MaskFF123
PaperFF456
FoodFF789
CoffeeTT127
AA

How to do this with Qlikview Script?

Thanks in Advance..!!

3 Replies
calvindk
Creator III
Creator III

If(Class = '', 'AA', [Product Category]) as [Product Category]

Not applicable
Author

But For AA no product class is defined.

It is for future. IF any other Product class is added other that mentioned  Product class. it will be considered as Product class for category'AA'

How to do it in Qlikview script?

calvindk
Creator III
Creator III

If Class(the number) for a line is missing then set product category (the characters) to AA else use current Product Category

If(Class = '', 'AA', [Product Category]) as [Product Category]

Maybe you are trying to achieve something else and i just dont understand what that is yet.

In that case my apologies.

Best wishes