Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..!!
If(Class = '', 'AA', [Product Category]) as [Product Category]
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?
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