CrossTable with Month

[Brownie]

Hey  I wanted to ask you whether how to convert The Given Excel sheet numbers or some kind of id perhaps into month names. Also i need to extract this data into months and dates according to the year dynamically into a Cross Table

[MayilVahanan]

Hi

Try like below

Temp:
CrossTable(Month, SalesQuantity,2)
Load * from ursource;

Load BusinessArea, Product, SalesQuantity, MonthName(Num#(Month)) as MonthYear, Month(Num#(Month)) as Month Resident Temp;

DROP Table Temp;

Please confirm Month field is numeric or Text format after load into Qlik.

If its Text format, use Num#(Month)

If its numeric format, MonthName(Month) is fine.

[Brownie]

I need to show all the missing days in it. How do i calculate the start and end effectively ?