Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

"Fiscal week number of Qtr" based on Created date dimension

I am looking for "Fiscal week number of Qtr" so it would be like FY17 Q1 - Wk1 to FY17 Q1 - Wk13 for Q2 it would be FY17 Q2 - Wk1 to FY17 Q2 - Wk13 and so on for Q3 and Q4. I am using web version of qlik sense so need expression so that i can use it as Dimension in report. I have "Created date" as dimension and i want expression to modify it so that it shows Fiscal week number of Quarter. Also my fiscal year starts from April and First saturday of april. Same goes for Quarter, first saturday of Qtr start month (Apr,Jul,Oct,Jan) would be first day of quarter.