How can convert date in month and Year Format in Qlik Sense
I have data (attached screen shot) as month in date format. Requirement is make a data in month and year format.
I have used cross table and transpose from column into row format in qlik sense. I am getting month but excel file containing data from Dec2016 to Dec 2017. I am able to see year 2017 in Year filter pane but no able to view year 2016.
i used calendar for month and Year as well but still year 2016 is not reflecting in QLIKSense.
I have two data file in excel format as data containing in the attached screen shot format.
Also, creating synthetic key only for "12/31/2016" and moth, let me know how to resolve it and how will get year 2016 in year filter pane.
Please advise me and provide the solution to fix this issue.
Appreciate for quick response..I want to fix this issue in the next 24 hours and it's a client requirement