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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2017-02-23 11:40 AM

Finding the rating in interval

Hi,

Please give me a solution for this

rating.PNG

These are the data i have from this I need to find out the current rating and previous rating I have scenarios where I will have many no.of AppraisalDates(AppraisalfromtDate,AppraisaltoDate) and I want to calculate if an employee starts the appraisal date from April(4/30/2016) to March(3/30/2017)  i want show  first 6 month as  previous rating and next 6 months as current rating

rating1.PNG

And also I want to show the Start and End Months in chart like 'Jan to June'

   Can anyone suggest me how we can do that?

342 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2017-02-24 07:13 AM
Author

Hi,

For month names, you can use the function MonthName to get dates such as 'Jan'

299 Views
0 Likes