topic Aggregating data? in QlikView

Aggregating data?

Tue, 06 Dec 2011 11:19:49 GMT

Hopefully this is a fairly simple one:

I am making a simple bar chart on my dashboard that is showing coursecreatedates vs. course revenue. The problem I am having is that the chart is showing one bar per each course creation and not, as i want, one bar per date summing/ aggregating the revenue for each day;

e.g. currently; 5 bars of £Xk on 05/12/2011, instead of £5Xk on 05/12/2011.

Is this just a simple aggregation forumula that i need to add as a calculated dimension?? I have a fairly long expression that calculates the course revenue which may be complicating things.

Would be grateful if someone can give me a nudge in the right direction.

Thanks.

Aggregating data?

swuehl — Tue, 06 Dec 2011 11:27:22 GMT

Could it be that your are using a timestamp as creation date (even if formatted as Date without time)?

Try a

=daystart(coursecreationdate)

as dimension.

If this works, you could change the timestamp to date in your script also.

Hope this helps,

Stefan

Aggregating data?

Tue, 06 Dec 2011 11:37:25 GMT

Just the job. Thanks for your help Stefan.

Much appreciated,

Laurence