Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi Gysbert,

Thank you so much i got it.

View solution in original post

3 Replies
Gysbert_Wassenaar

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
Anonymous
Not applicable
Author

Hi Gysbert,

Thank you so much i got it.

vardhancse
Specialist III
Specialist III

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.