topic Re: Sum value for the last day in QlikView

Sum value for the last day

Mon, 18 Jun 2012 15:17:31 GMT

Hi all!

I'm trying to do a expression that´s summarize the amount/value for the last day. I,ve a date field with the format YYYYMMDD and the field that a summurizing is integer.

Any one that have a good solution?

Thanks in advance!

Re: Sum value for the last day

Mon, 18 Jun 2012 15:29:18 GMT

could you give a data sample? with result expected?

Re: Sum value for the last day

Mon, 18 Jun 2012 15:30:41 GMT

Hi Larssbjorn,

I saw you have 2 similar topics now, one for week and one for per day... Perhaps a bit overkill; i hope you didn't plan to open one for quarter, year, decade etcetera 🙂

For me, your question is still a bit unclear.

[1] Last day of what? Of all values loaded? Or per week or month?

[2] Summarize...? Just a sum? or other way of summary (count or...?)

Can you give some more info?

Re: Sum value for the last day

Thu, 21 Jun 2012 07:20:03 GMT

I use a expression like this but it doesn´t give me that result I expected:

sum({<DateField={"$(=Date(today()-1,'YYYYMMDD'))"}>} ValueField)

Re: Sum value for the last day

Thu, 21 Jun 2012 09:40:21 GMT

A small demo-app would be handy, so we can check your problem. Could you attach that?

When you don't assign a label to your expression (as column heading) you can check (by hovering (mouseover) the column header...) what the setexpression is (e.g. if you today()-1 is calculated correctly).

I think your expression returns null, and that that is the reason why it goes wrong.

Perhaps this helps, otherwise I hope you can provide a small sample app with the problem.