topic Re: Help require for Qlikview Scripting..!! in QlikView

Help require for Qlikview Scripting..!!

Tue, 20 Aug 2013 17:48:20 GMT

Hi All,

I have table like below:

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:

How to do this with Qlikview Script?

Thanks in Advance..!!

calvindk — Tue, 20 Aug 2013 17:55:30 GMT

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

Tue, 20 Aug 2013 18:00:28 GMT

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 — Tue, 20 Aug 2013 18:05:19 GMT

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