Discussion Board for collaboration on QlikView Scripting.
I Have a list Box with month field. which is from Jan to Sep.
But i want to display only Jan to jun which is Jan to max(Month)-3.
How can this be achieved in list box.
Try using a variable
vMaxMonth = Max([Month])-3
=IF(AGGR([Month], [Month])<=$(vMaxMonth), [Month])
May be try this
If(Month <= Max(TOTAL Month) - 3, Month)
Else, If Month field is a string - Then try this?
If(Num(Month(Date#(Month,'MMM'))) <= Max(TOTAL Num(Month(Date#(Month,'MMM')))) - 3, Month)