topic Re: How to display only few months in List box in QlikView

How to display only few months in List box

naveen341 — Fri, 09 Nov 2018 16:23:14 GMT

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.

vamsee — Fri, 09 Nov 2018 22:25:33 GMT

Try using a variable

vMaxMonth = Max([Month])-3

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

sunny_talwar — Wed, 14 Nov 2018 01:31:09 GMT

May be try this

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

Anil_Babu_Samineni — Wed, 14 Nov 2018 03:26:34 GMT

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)