Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

List Box

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?

3 Replies

Re: List Box

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!

Not applicable

Re: List Box

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

Not applicable

Re: List Box

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.

Community Browser