line chart expression which involves aggregation - not ignoring date selection

[#1]

Hi All,

I am new to Qlikview and I hope someone helps me with this issue.

I am trying to get people count for all the Dates in a Line chart but I am not able to find a right expression which involves aggregation.

I tried below expression:

                                        Sum(Aggr(FldPeopleCount,  Year, Department, country )) => Peoplecount

This expression gives below line chart. A blue dot for  FldPeopleCount (Aggregated) only for the current date(DateField) - 15/03/2013.

But I want Peoplecount for all the dates with aggregation for FldPeopleCount. Below is the required line chart which shows data for all the dates:

I have been trying many expressions but I am not able to find a correct expression which ignores date selection and gives the above graph. 

Please help me with this expression. Thanks in advance!

[udit_kumar_sana · Accepted solution]

Hi ,

Please find here below the attached  file ,for your issue.

Regards,

Udit

[#3]

Hi Udit,

Thank you !

That worked for all dates but had to make some more changes in the script to get accurate results.