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!

[#2]

Any suggestions ? I tried this expression. It did not work.

sum(Aggr(Sum({<DateFeild=>})FldPeopleCount), Year, Department, Country)

[#3]

Hi dshreegiri,

try this expression,

sum(aggr(sum(FldpeopleCount)),datefield,year,department,country)

[#4]

Hi nirmal,

Thanks for the reply.

It did not work. I want to ignore date selection. Your expression shows data for only the selected date.

[#5]

ok try this

sum(Aggr(Sum({$<DateFeild=>})FldPeopleCount), Year, Department, Country)

[#6]

dts not working

[#7]

Can you upload your sample application

[#8]

I dnt think I can upload that application it has some confidential information.

[#9]

Iam asking just sample application

[#10]

Sample application