4 Replies Latest reply: Oct 16, 2012 5:13 AM by Anju Gopinath RSS

    creating dimension from column value and finding sum of columns

      Hi ,


      I am looking for a solution to the below described solution...



      I have a query which returns the following result



      But, in qlikview, i want to model it slightly differently in a chart..



      i.e. i want to pull out each individual value from 'batch_month' field and make it a dimension...and enter the corresponding fpr_brl_amount under it.

      Also, at the end, I want to create a new colum 'Accumulated' that will sum all the values in the row.


      I tried something, but it was giving me 'accumulated' field after each month..


      I have attached a file detailing the query and the chart details.


      Can anyone help me out with this, please?