This is my data i want to create master calendar MTD, YTD on the basis of the field
Hi,
You need to include at least year while generating calendar using makedate function in qlik
for eg
MakeDate(transaction_year, transaction_month, transaction_day) as "Transaction Date",
transaction_day = 01 first day of every month
after generating date this you need to create master calendar using this date.
Vikas