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?

       

      Regards,

      Anju