Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

harindersingh
Not applicable

Data Till Current Date with buckets

          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

Tags (1)
1 Solution

Accepted Solutions
harindersingh
Not applicable

Re: Data Till Current Date with buckets

Hi Gysbert,

Thank you so much i got it.

3 Replies
Gysbert_Wassenaar
Not applicable

Re: Data Till Current Date with buckets

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.


talk is cheap, supply exceeds demand
harindersingh
Not applicable

Re: Data Till Current Date with buckets

Hi Gysbert,

Thank you so much i got it.

vardhancse
Not applicable

Re: Data Till Current Date with buckets

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.