Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
naveen341
Creator
Creator

How to display only few months in List box

Hi Guys

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.

Thank you

Naveen.

3 Replies
vamsee
Specialist
Specialist

Try using a variable

vMaxMonth = Max([Month])-3

=IF(AGGR([Month], [Month])<=$(vMaxMonth), [Month])

sunny_talwar

May be try this

 

If(Month <= Max(TOTAL Month) - 3, Month)

 

 

Anil_Babu_Samineni

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)

 

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful