3 Replies Latest reply: Mar 9, 2015 4:03 PM by anitha lux RSS

    List Box

    anitha lux

      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

          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
            Shawn Hicks

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