Discussion board where members can get started with Qlik Sense.
i have below field is like that i need change as yyyy/mm kindly plz help me to find correct solution for the problem
Solved! Go to Solution.
If that's an XL file then
Select your dates>Right click>Format Cells>Custom>Select any value and Type YYYY/MM>Ok
Again select all dates>click on the ! icon on the left>Convert to XX to 20XX
Keep in mind that this will be still kept as a separate date for each day of month so to convert it to month-year value you will have to use something like:
Date(MonthStart(Date#(Period, 'YYYYMM'), 'YYYY/MM')))
then when you use this column in listbox you will fin one instead of 28,29 or 30-31 the same looking values in each month.