14 Replies Latest reply: Jan 16, 2017 3:56 AM by Yeo Poh sai RSS

    How to make QV display the max year sales ? As My customer sales some not all of them have 2015 & 2016 sales

    Yeo Poh sai

      Hi All

       

      This expression return 2015 sales

       

      Sum({<year = {$(=Max(if(getselectedcount(year)=0,2015,year))-0)} , month = {"<=$(=Max({<year={$(=Max(if(getselectedcount(year)=0,2015,year)))}, sales = {'*'}>} month))"} >} REVENUE_C/1000000

       

      )

       

       

      This expression return 2016 sales

       

      Sum({<year = {$(=Max(if(getselectedcount(year)=0,2015,year))-0)} , month = {"<=$(=Max({<year={$(=Max(if(getselectedcount(year)=0,2015,year)))}, sales = {'*'}>} month))"} >} REVENUE_C/1000000

       

      )

       

      My data some only have 2016 sales , all of them have 2015 sales.

      How to make the above expression take 2015 sales when 2016 no sales ?

       

      How to make the above expression take 2016 sales when 2016 have sales ?

       

       

      So that i can display both.

       

      Now only TDS and ADL have 2016 data. Other only have 2015 sales data.

       

       

      Paul