Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you provide an example dataset and expected output?