19 Replies Latest reply: Oct 5, 2017 7:08 AM by pradosh thakur RSS

    add a target on the pivot table

    ben lim

      is it possible to add a target (customized column) on pivot table in qlikview.

       

      see attached.

       

      dwdd.PNG

       

      i would like to add a hard coded 'target' in between Date and the city.

       

      do note that i designed in a way that i need > 1 expression in the table. (i could have add city on dimension and expression to be sum(sales) but it doesnt work in this way).

       

      let me know if it makes sense