Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart based on Today()

Hi All

I want to create the chart which counts the ID based on the following date values Today()-14,Today-30,Today()-90 and YTD. I thought of doing it by passing these days values in the cyclic group. Is it the right way of doing it. I am little confused how to do this. Does any one have sample application which does the same thing? If you can attach it will be helpful for me.

Regards

Attitude

22 Replies
Not applicable
Author

I think instead of using today() in the below code I need to pass some date which gives the yearstart of my own calendar.  Got stuck here, don't know how to pass that.  Also not sure which date field should be passed here which gives the yearstart on my own calendar.

Date(yearstart(today()))

Not applicable
Author

Hi Stefen

The one which you have posted yesterday may not work as we have hardcode the year start there. Where as in my case yearstart keep changing. So if time permits kindly give some solution for me please.

Regards

Attitude

swuehl
MVP
MVP

So how ist your yearstart defined? What is the rule behind? Is it lunar

based?