8 Replies Latest reply: Nov 1, 2015 8:56 PM by Jim Chan RSS

    New store and existing store comparison

    Jim Chan

      Hi guys,

       

      i need to create something that it is able to let me know what's my new store sales , what's my existing store sales.

       

      i have a table as such:

      store nameSalesYear
      store A1m2015
      store B2m2015
      store A1m2014
      store B02014

       

      from the table of cos i know store b is new store as there's no sales in 2014, but 2015. but in Qlikview, how can I achieve something as below:

       

      Assuming i have set to YTD- 2015

      All Store:3m

      New Store: 1m