topic Re: return value based on condition set in QlikView

return value based on condition set

Anonymous — Wed, 16 Sep 2015 13:19:14 GMT

Hi,

I would like to show a straight table with a column "Product Name",

available products are:

A. 1,2, 3.....30 (30 different products from the same family)

B. and also products 100, 101, 102...109 (10 different products from the same family)

C. and also products 110, 111, 112...119 (10 different products from the same family)

D. and also products 120, 121, 122...129 (10 different products from the same family)

If the client purchased Product from B family, show the name, if not,

If the client purchased Product from C family, show the name, if not,

If the client purchased Product from D family, show the name, if not,

show nothing.

How can I create such a logic?

I use

sunny_talwar — Wed, 16 Sep 2015 13:24:11 GMT

May be something like this:

If(Len(Trim(Product)) = 2, 'A',

If(Match(Product, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109), 'B',

If(Match(Product, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119), 'C', 'D')))

Anonymous — Wed, 16 Sep 2015 13:32:51 GMT

cool,

how can I return the specific product (not the family)

sunny_talwar — Wed, 16 Sep 2015 13:34:17 GMT

Not sure what you mean?

Anonymous — Wed, 16 Sep 2015 13:54:23 GMT

Sorry I wasn't clearer,

I would like to present the product name to the user,

according to the logic above

sunny_talwar — Wed, 16 Sep 2015 13:58:08 GMT

Are you trying to do this in the front end of the application or backend?

For backend I would suggest creating a new column for Product Name using Product ID:

LOAD [Product ID],

'Product ' & [Product ID] as [Product Name]

...

FROM Source;

settu_periasamy — Wed, 16 Sep 2015 13:59:25 GMT

May be you can try the sunny's solution in opposite way..

If(Product<=30,'Product 1-30',

If(Product>=100 and Product<110,'Product 100-109'))

....