0 Replies Latest reply: May 10, 2012 8:29 AM by Jose Vicente Pla Gallego RSS

    How to use the chart.apis.google in Sales Overlap?

      Hi, I want to make the sales overlap chart like the example in the what`s new in qv 11 but I don´t undesrtand  the sintax of the expression and I don`t know what is the function p().

      Any body can help me?

       

      ='http://chart.apis.google.com/chart?cht=v&chs=330x220&'&

      //'chtt=Invoices shared among products&' &

      'chdl=' & Minstring({<Index = {73}>} [$(vLanguage)])& '|' &

      'x' & Minstring({<Index = {69}>} [$(vLanguage)]) & ' = ' &

      count({$<[Invoice Number] = p({$} [Invoice Number]) * p({[Group 1]<Path = $::Path, Region = $::Region, Year = $::Year, Quarter = $::Quarter, Month = $::Month>} [Invoice Number])>} DISTINCT [Invoice Number]) &  //' shared' &

      '|x' & Minstring({<Index = {70}>} [$(vLanguage)]) & ' = ' &

      count({$<[Invoice Number] = p({$} [Invoice Number]) * p({[Group 2]<Path = $::Path, Region = $::Region, Year = $::Year, Quarter = $::Quarter, Month = $::Month>} [Invoice Number])>} DISTINCT [Invoice Number]) &  //' shared' &

      '&' &

      '&chco=FFCC00,9AB2CD,BDCBB3&'&

      'chd=t:'&

      round(count({$} DISTINCT [Invoice Number])/vMaxSetScale,1)&','&

      round(count({[Group 1]<Path = $::Path, Region = $::Region, Year = $::Year, Quarter = $::Quarter, Month = $::Month>} DISTINCT [Invoice Number])/vMaxSetScale,1)&','&

      round(count({[Group 2]<Path = $::Path, Region = $::Region, Year = $::Year, Quarter = $::Quarter, Month = $::Month>} DISTINCT [Invoice Number])/vMaxSetScale,1)&','&

      round(count({$<[Invoice Number] = p({$} [Invoice Number]) * p({[Group 1]<Path = $::Path, Region = $::Region, Year = $::Year, Quarter = $::Quarter, Month = $::Month>} [Invoice Number])>} DISTINCT [Invoice Number])/vMaxSetScale,1)&','&

      round(count({$<[Invoice Number] = p({$} [Invoice Number]) * p({[Group 2]<Path = $::Path, Region = $::Region, Year = $::Year, Quarter = $::Quarter, Month = $::Month>} [Invoice Number])>} DISTINCT [Invoice Number])/vMaxSetScale,1)&','&

      round(count({[Group 1]<[Invoice Number] = p({[Group 1]<Path = $::Path, Region = $::Region, Year = $::Year, Quarter = $::Quarter, Month = $::Month>} [Invoice Number]) * p({[Group 2]<Path = $::Path, Region = $::Region, Year = $::Year, Quarter = $::Quarter, Month = $::Month>} [Invoice Number])>} DISTINCT [Invoice Number] )/vMaxSetScale,1)&','&

      round(count({$<[Invoice Number] = p({$} [Invoice Number]) * p({[Group 1]<Path = $::Path, Region = $::Region, Year = $::Year, Quarter = $::Quarter, Month = $::Month>} [Invoice Number]) * p({[Group 2]<Path = $::Path, Region = $::Region, Year = $::Year, Quarter = $::Quarter, Month = $::Month>} [Invoice Number])>} DISTINCT [Invoice Number])/vMaxSetScale,1)