I need one extra field between 1st field and last 3 fields. the 1st field is the dimension and the last last 3 fields are column added with measure values. I want a field in between the two, which show sum of Feb, Mar and Apr results. I need some help.
When i am trying to add a measure, it is getting into column. I don't want this to happen, i want a separate field.
Shraddha, my concern is I can not add a field. Unless I add a field I can not apply the formula in it. As I am new to Qlik, I would highly appreciate if you help me for the same. / See picture above, it has 4 fields, I want to make it 5, use the fifth one and apply the formula you gave. /
I tried adding column, row and measure from Data Section of pivot table as well, but this does not help me.
dear Shraddha, let me tell you my exact requirement. As you see in the attached picture.
The first column named 'FirstMonth' is the name of the month we want to consider, second column 'Reg Users' shows number of users registered in that month only, whereas all subsequent month shows number of customers are placing their orders(please see row wise here).
in column sep-13 value = 7
in column oct-13 value = 14
in column nov-13 value = 18
, this simply means out of 176 users who get registered in sep-13, only 7 are placing orders in sep-13, 14 are placing orders in oct-13, 18 are placing order in nov-13.
Note: for all above value we are considering only customers who got registered in Sep-13 only.
though I have got value of individual months, like sep, oct and nov, I can not get total number of registered users, because I can not include a new field. ! !
I hope my above explanation is clear. Please see attached file as well