Discussion board where members can get started with QlikView.
How can we do a sum on change of a dimension?
Calculate the salary received till today on change of employee name which is a dimension?
What happens now is it calculates sum of all the salaries.I need the sum for each employee or when Emp Name changes?
How to achive that
Not sure if I understand,
but if you create e.g. a straight table chart and out [Emp Name] as dimension, and as expression
, you get the total of all Salaries in each line? Then you need to check you data model, could you tell us a bit more about it (how the tables are defined and how they are linked)?
First of all thanks for your reply.
I tried this but its summing up everything.
Ok, but how does your data model look like?
It seems to me that the table that contains [Emp Name] field is not correctly linked to the table containing Salary field.
Forgot to mention its just one view from where it is coming so no linking is there anyway.
That sounds strange, then. Is there a possibility that you upload a small sample (upload available in advanced editor)?
Seems strange but works now.
Thanks for the help anyway.
i had shut qlikview and started again.