Calculate Month from Corresponding Week Number

[qliky88]

Hi Experts, 

Just wondering is it possible to calculate a month from a corresponding week number? 

I have a line chart with week number dimension - would be nice if user could filter week number separately and have the corresponding month display on a KPI 🙂 

Thanks !

[Kushal_Chawda · Accepted solution]

If you have a Date field then you can generate the master calendar with all the required time dimensions like week,month quarter etc.

[qliky88]

Hi @Kushal_Chawda , how would I go about generating a master calendar? 

[Kushal_Chawda]

look at here https://community.qlik.com/t5/QlikView-Scripting/Creating-A-Master-Calendar/td-p/341286