topic Re: List Box in QlikView

List Box

Thu, 12 Feb 2015 20:11:46 GMT

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?

Re: List Box

Oleg_Troyansky — Thu, 12 Feb 2015 20:42:36 GMT

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!

Re: List Box

Mon, 09 Mar 2015 16:25:45 GMT

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...

Re: List Box

Mon, 09 Mar 2015 20:03:32 GMT

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.