Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a data set with data dating back to 2013. However, the report I am intending to create is requires only year to date.
Please advise.
thanks!
Hi Guohao
Check out this video A Beginners' Introduction to Set Analysis (video)
Using Set Analysis - you can use an expression in a measure that will lock your chart object to a particular set of data such as:
Sum({$<Year={'2013'}>}Sales)
Let us know if that is what you needed.
You can further expand on this with other filters being taken into consideration.
(UPDATED WITH CORRECT LINK) More videos like this are available here: New to Qlik Sense Videos
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Regards,
Mike Tarallo
Qlik
Hi Guohao
Check out this video A Beginners' Introduction to Set Analysis (video)
Using Set Analysis - you can use an expression in a measure that will lock your chart object to a particular set of data such as:
Sum({$<Year={'2013'}>}Sales)
Let us know if that is what you needed.
You can further expand on this with other filters being taken into consideration.
(UPDATED WITH CORRECT LINK) More videos like this are available here: New to Qlik Sense Videos
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Regards,
Mike Tarallo
Qlik
In order to produce a YTD total, and especially when you need to compare it with the Prior YTD, it's advisable to create a set of flags in your Calendar table:
_CYTD_Flag for the Current YTD totals, and
_PYTD_Flag for the Prior YTD totals.
The flag is a 1/0 field, and it can be used either in Set Analysis, or simply by multiplication. There is plenty of information about using conditional flags - search this forum, or check out my new book QlikView Your Business.
cheers,
Oleg Troyansky
QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense
Also check if the below can help you for YTD calculations
This comes with flags
I'm attaching the script and sample data, please check
Thanks
Satish
Yup. The video is indeed very helpful. The master calendar might be useful too for others who are looking at the same issue. You can add the YTD flag like what Satish suggest.
thanks all!
Thanks Guohao - here is a more updated video you may find interesting:
Understanding the Master Calendar (video)
Mike