7 Replies Latest reply: Mar 25, 2016 2:36 AM by kushal chawda RSS

    [URGENT] - Need help in Filter in calculated dimension!

    Jim Chan

      Hi guys,

       

      I have issue regarding the filteration in the calculated dimension. Have a look at my picture1.

      PICTURE1.png

      The ‘Data’ table box is the original data load from the excel file. Now, have a look on my picture 2.

      PICTURE2.png

      To differentiate the category of the customer, I have used the calculated dimension as shown as below:

       

      Category Expression:

      = if(Date <= '$(vSelectYear)' AND ISNULL(Date2), 'Not New Customer',
      if(Date <= '$(vSelectYear)' AND Date2 <> null(), 'Others',
      if( Date > '$(vSelectYear)', 'New Customer', 'None'
      )))

       

      Sales Expression:

        = sum(Sales)


      Now, at my final picture3.

      PICTURE3.png

      Unfortunately, when I click the ‘Not New Customer’ in the Category column, it is unable to filter the Category. It also showed the value ‘Others’ also.


      So, is it possible to filter the calculated dimension in the qlikview which is when I click the ‘Not New Customer’ it only shown the ‘Not New Customer’ only in the straight table?


      Rgds,


      Jim