8 Replies Latest reply: Apr 22, 2016 6:59 PM by Carmen Valencia RSS

    Line chart with x axis in%

    Carmen Valencia

      Hi:

       

      I will trying to do this chart  into qlikview,   but  I did not find how to put x-axe in %, this char is done in Excel.

       

      I am used a pick in expresión

      =pick(
      Match(
      ValueList('Inventario (Cjs)','Inventario ($$)','Cobertura(Dias)','Rotacion(Vueltas)', 'No. SKUs'), 'Inventario (Cjs)','Inventario ($$)','Cobertura(Dias)','Rotacion(Vueltas)', 'No. SKUs')

      ,sum( CantidadGlobal)
      ,sum((CantidadGlobal* CostoGlobal) / 1000)
      ,((sum(CantidadGlobal* CostoGlobal) / sum({<Mes=, IDFECHA={">$(vfechaini) <=$(vfechafin)"} >}  PronosticoDiario * Costo) / 3) * 30)
      , 365 / ((sum(CantidadGlobal* CostoGlobal ) / sum({<Mes=, IDFECHA={">$(vfechaini) <=$(vfechafin)"} >}  PronosticoDiario * Costo)) * 30)
      ,count (distinct CodProducto)
      )

      and is correct that how shows the values, but I need shows x-axe in porcent similar to Excel chart, the next char is how shows qlikview

       

      Title was edited by Community Moderator for English translation.