Pattern of nested if

[#1]

Hello all,

I realized Qlikview is limited to a 100 nested if. What I am trying to do is "relabel" the labels I have for different transactions.

For example: "15072016 77635536 MCDONALDS UUTZR" I want to have another column "Subcategory" with mure "cleaner labels" in which it would be written "McDonalds" for this one.

The nested if method is working fine:

  if( index([Label operation], 'TAXI')<> 0 ,'Taxi',           // Here Label operation is : 425252 TAXIG763355

  if( index([Label operation], 'BURGERKING')<> 0 ,'Burger King',     // Here Label operation is :16072016 BURGERKING37R38

  'Others' AS Subcategory

But I have many label to rename more than 100 and thus , if nested does not work anymore.

I was trying to investigate ApplyMap, but note sure how I would use it. It should be something not sor far to this:

ApplyMap('map1', [Label operation],'Others') As Subcategory

But I guess I have to still use index function.

Let me know if you come up with a nice idea

Thanks.

M.

[#2]

Crystal clear and working perfect

Again big thanks Stefan, this helps me a lot !

M.