Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Dhruva1
Contributor II
Contributor II

Need expression for Previous month of max cycle id

Qlikview Requirement:

Every week one id will generate so on every Monday one id will generate so every month has 4 id's so I need a expression for previous month of max id.

Example:

Sep month as 4 id's

1st week  201 id

2nd week 202 id

3rd week 203 id

4th week 204 id

As per my requirement, Current month is Oct so previous  month is sep so how to write an expression to fetch data for 4th week of sep month id dynamically. 

1 Reply
Albarosæ
Contributor III
Contributor III

Can you provide an example dataset and expected output?