Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
TS08
Contributor II
Contributor II

Dimension - Dynamic Forecast Slab

Hi, Can anyone help me create a espression for this below business logic?

 

e.g.

If Forecast Date < today() i.e. 23rd Sep and Prior then outcome should be ‘5) Forecast Missed’,

If Forecast Month = ‘Blank’ then outcome should be ‘6) No Forecast’,

If Forecast Month = today's month i.e. September then outcome should be ‘1) Sep-22’,

If Forecast Month - today's month = 1 i.e. October then outcome should be ‘2) Oct-22’,

If Forecast Month - today's month = 2 i.e. November then outcome should be ‘3) Oct-22‘,

Or else

‘4) >3 Months’

 

Thanks

Labels (3)
0 Replies