topic Re: line chart expression which involves aggregation - not ignoring date selection in QlikView

line chart expression which involves aggregation - not ignoring date selection

Mon, 18 Mar 2013 00:39:50 GMT

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!

Re: line chart expression which involves aggregation - not ignoring date selection

Mon, 18 Mar 2013 03:42:46 GMT

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

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

Re: line chart expression which involves aggregation - not ignoring date selection

Mon, 18 Mar 2013 03:59:59 GMT

Hi dshreegiri,

try this expression,

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

Re: line chart expression which involves aggregation - not ignoring date selection

Mon, 18 Mar 2013 04:06:37 GMT

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.

Re: line chart expression which involves aggregation - not ignoring date selection

Mon, 18 Mar 2013 04:13:31 GMT

ok try this

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

Re: line chart expression which involves aggregation - not ignoring date selection

Mon, 18 Mar 2013 04:20:18 GMT

dts not working

Re: line chart expression which involves aggregation - not ignoring date selection

Mon, 18 Mar 2013 04:22:30 GMT

Can you upload your sample application

Re: line chart expression which involves aggregation - not ignoring date selection

Mon, 18 Mar 2013 04:34:32 GMT

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

Re: line chart expression which involves aggregation - not ignoring date selection

Mon, 18 Mar 2013 04:35:54 GMT

Iam asking just sample application

Re: line chart expression which involves aggregation - not ignoring date selection

Mon, 18 Mar 2013 04:56:55 GMT

Sample application

Re: line chart expression which involves aggregation - not ignoring date selection

udit_kumar_sana — Mon, 18 Mar 2013 06:12:28 GMT

Hi ,

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

Regards,

Udit

Re: line chart expression which involves aggregation - not ignoring date selection

Mon, 18 Mar 2013 23:37:13 GMT

Hi Udit,

Thank you !

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