topic Data Till Current Date with buckets in QlikView

Data Till Current Date with buckets

Anonymous — Wed, 05 Aug 2015 06:17:09 GMT

Hi,I am stuck in one problem

I want to show YTD count and it should be dynamicly change every day along with buckets. That YTD Feild and Buckets are created in Script in that Buckets are working fine and YTD data is created based on Today Function. It is giving correct value for current month but if we move previus month it is showing a same value becouse of today function.Anything alternative of Today function that will helpful

I have attached the Screen shot of requriment how i need this and also i atteched QVW i which i had worked

I want to create this logic in script level only beacouse after this i also need to include more things in my pivot table.

Please help me out to solve this problem i really aprreciate your help

Re: Data Till Current Date with buckets

Gysbert_Wassenaar — Thu, 06 Aug 2015 08:37:02 GMT

You can find out how to do this in this document: Calculating rolling n-period totals, averages or other aggregations. There's a YTD example in the AsOf Table Examples.qvw file attached to that document.

Re: Data Till Current Date with buckets

Anonymous — Thu, 06 Aug 2015 10:54:45 GMT

Hi Gysbert,

Thank you so much i got it.

Re: Data Till Current Date with buckets

vardhancse — Thu, 06 Aug 2015 10:56:18 GMT

Can please close the thread if you got correct answer. so that might be helpful to another without creating one more duplicate thread on the same.