Discussion board where members can get started with Qlik Sense.
i have scenario, i have a month column present and it is displaying values like 1.2.3..etc but here instead of 1,2,3 i want to display 01,02,03..etc
Thanks in advance.
Go to Solution.
Try below one:
Date(Month(MonthField),'MM') As MonthField
Num(month,'##') as month
thanks for your reply,
still expected values are not coming.
post sample data Apps.
What are the values it giving?
now values are displaying 01,02 ..etc thanks, Sharaddha
Hi, try date(makedate(date_field),'YY') as date_field