topic Re: Show the value at Month End in QlikView

Show the value at Month End

Dayna — Tue, 13 Mar 2012 15:42:27 GMT

Hello All,

I have a list of data that shows the inventory for each date, but what I would like to do is show what the value is at the of the month..

I've tried using monthend(Date) from a load statement, but this gives me the amounts within that month.

Please find attached an example report based on what I'm trying to do, please help!

Many thanks,

Dayna

Re: Show the value at Month End

jvitantonio — Tue, 13 Mar 2012 15:48:14 GMT

Here you go

Re: Show the value at Month End

Dayna — Tue, 13 Mar 2012 16:06:08 GMT

Hello, I don't want the sum of the values for the month, but just the individual value that's on the date that's the end of the month. So the value on the example for the 29/02/2012 would be 54. Hope that makes sense! Many thanks, Dayna

Re: Show the value at Month End

jvitantonio — Wed, 14 Mar 2012 08:29:01 GMT

Oh, ok, I get it. You can do ir directly in a pivot table. No need to create a new table or duplicate data in memory. Anyway, if you need to create a new table, I wrote also the script and commented it out.

I hope this helps.