Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

naveen341
Contributor

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
Valued Contributor

Re: How to display only few months in List box

Try using a variable

vMaxMonth = Max([Month])-3

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

Re: How to display only few months in List box

May be try this

 

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

 

 

Re: How to display only few months in List box

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)

 

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)