Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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?