List Box

[#1]

I have created a list box with the expression :

if(SERVICE_TIER = 'type1','type1',

IF(SERVICE_TIER = 'type2','type2',

IF(SERVICE_TIER = 'type3','type3','Internal')))

The list box shows up correctly in the development server. But on accesspoint it just shows up as internal (*4times) instead of the {type1,type2,type3,internal}

How to fix this?

[Oleg_Troyansky]

I'm surprised it works in the development server... Based on my understanding, it shouldn't...

Try this:

=AGGR(

   if(SERVICE_TIER = 'type1','type1',

   IF(SERVICE_TIER = 'type2','type2',

   IF(SERVICE_TIER = 'type3','type3','Internal')))

, SERVICE_TIER)

cheers,

Oleg Troyansky

Come and learn Set Analysis and Advanced Aggregation with me at www.masterssummit.com - take your QlikView skills to the next level!

[#3]

I would recommend moving this logic to the script as create field/attribute with the same logic then use that field in the list box.  It will provide more consistent results and also be useful in set analysis.

load

...

if(SERVICE_TIER = 'type1','type1',

IF(SERVICE_TIER = 'type2','type2',

IF(SERVICE_TIER = 'type3','type3','Internal'))) as Service_Tier_Type

from...

[#4]

Thanks for your response.

I created a LOAD table with the SERVICE_TIER field and map Field ,  and used apply map in the table .It seemed to have fixed the problem.