8 Replies Latest reply: Mar 3, 2014 4:57 AM by Paul Yeo RSS

    How to have 1 list box for 3 field ?

      Hi All

       

      Below will only recode core Brand :-

       

          pick(1+match(if(len(trim(@282:298)),@282:298,subfield(@207:240,' ',1))

                  ,'HAKKO','BECKHOFF','MITSUBISHI','MITSUBISH' ,'GE FANUC','GE','PROJECT','')

          ,'OTHER','HAKKO','BECKHOFF','MITSUBISHI','MITSUBISHI','GE FANUC','GE FANUC','PROJECT','') as [BRAND_MISC],

         

      Below will recode all Brand :-

       

          pick(1+match(if(len(trim(@282:298)),@282:298,subfield(@207:240,' ',1))

                  ,'HAKKO','BECKHOFF','MITSUBISHI','MITSUBISH' ,'GE FANUC','GE','HENGSTLER','SCHAFFNER','REDLION'  ,'HMS','PROJECT','SECOMEA','KEB'  ,'')

          ,'OTHER','HAKKO','BECKHOFF','MITSUBISHI','MITSUBISHI','GE FANUC','GE FANUC','HENGSTLER','SCHAFFNER','REDLION','HMS','PROJECT','SECOMEA','KEB'  ,'') as [BRAND_],

       

      Notice the diff is :-

       

      BRAND_MISC hv only 7 Brand

      BRAND_ hv more then 7 Brand.

       

      So there are 2 type of Brand field.

       

      Reasons for above 2 field name of Brand :-

       

      when i plot sales by Brand using Table it is okay , i can view all brand sales. But for chart , sales by Brand ( Stack chart ) it is not possible to use BRAND_ , Because it will not able to view all sales , since too many small brand sales.

       

      when i need to create list box for user filter individual brand , it is easy to create list box with BRAND_MISC since it have only 7 brand.

       

      i need to create a list box using BRAND_ , why i am not able to use for BRAND_MISC ?

       

      A bit confuse right ? i feel it also ... now i create a qv doc to explain.

       

      Paul

       

      Paul