Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

0 Replies