Help require for Qlikview Scripting..!!

[#1]

Hi All,

I have table like below:

Product	Product Category	Class
Mask	FF	123
Paper	FF	456
Food	FF	789
Coffee	TT	127

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:

Product	Product Category	Class
Mask	FF	123
Paper	FF	456
Food	FF	789
Coffee	TT	127
	AA

How to do this with Qlikview Script?

Thanks in Advance..!!

[calvindk]

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

[#3]

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]

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