Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
my Location is Germany and I am a relatively new QV - Developer.
My next Task: Make comparisons of Dates/Periods, i.e. Years, Month, Quarter, Week (Last Period, Last Years Period).
I am convinced that there are a lot of possibilities, however, I am still searching for BEST PRACTICE.
May I ask the community to give me some workable procedures? Thanks a lot!
Wolfgang
Hi,
You can create variables like year=max(Year),previous year=max(year)-1 like this for month and week also
and then you can compare periods
Hope this will help you
Regards,
Vijeta
Wolfgang,
did you tryed to search here?
There are different ways to do period comparisions and you should choose one which will be the best for application, you create.
For the begining you may try Tools/Time Chart Wizard.
regards
Darek
Best practise would be to create a Master Calendar which flags Last Year, Last Years Period etc.
Fortunately, there are a lot of documents & forum post on that topic in this community.
I recommend reading blogs by HIC , like:
Hi,
You can also see the blogs or links
http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd
http://community.qlik.com/message/461745#461745
Regards,
Vijeta
Dear ,
Kindly find the attachment.
i hope it will help you.
Thanks,
Mukram.
Read this documents for period combinations
compare current year previous year
Read Steve Dark's Reply
Thanks to all of you, I am on a very good way, thanks to your Input!
Wolfgang