8 Replies Latest reply: Mar 7, 2018 1:18 PM by vivek anand RSS

    How to sort dimension by expression and remove some valus of dimension in QLik sense

    vivek anand

      Screenshot (226).png

      Dimension----Category

      Measure----Sum(Sales)

       

      First of all I have tried to sort the dimension values that I have done successfully by expression:-

      If(CategoryName='Men´s Footwear',1,

      if(CategoryName='Babywear',2,

      if(CategoryName='Children´s wear',3,

      if(CategoryName='Ladies´Footwear',4,

      if(CategoryName='Bath Clothes',5,

      if(CategoryName='Sportwear',6,

      if(CategoryName='Womens wear',7,

      if(CategoryName='Men´s Clothes',8

      ))))))))

       

       

      Now I want to remove some of the values from the dimension lik:-

      Babywear, Men's Clothes, Sportwear


      So, How can I do this?