topic Re: Restrict listbox to view only two months in QlikView

Restrict listbox to view only two months

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a listbox that lists my dates as months .General tab > field... given my month field here.

How should I frame a expression so I can just view max( month) and one prior month .???/

Anil_Babu_Samineni — Mon, 07 Aug 2017 10:18:12 GMT

May be use

Match(month, 'jan', 'feb')

tresB — Mon, 07 Aug 2017 10:44:11 GMT

Try like:

=Pick(Match(-1,Month=Max(total Month),Month=Max(total Month, 2)), Month, Month)

=If(Month=Max(total Month) OR Month=Max(total Month, 2), Month)

Chanty4u — Mon, 07 Aug 2017 11:25:25 GMT

try this

=aggr(only({<Month= {'Jan','Feb'}>}Dim),Dim)

Mon, 07 Aug 2017 11:36:42 GMT

Try this

MONTH_YEAR={">=$(=date(AddMonths(date((max(MONTH_YEAR)),'MM-YYYY'),-1),'MM-YYYY'))<=$(=date((max(MONTH_YEAR)),'MM-YYYY'))"}>}

sunny_talwar — Mon, 07 Aug 2017 11:51:28 GMT

Try this may be

If(Date >= Max(TOTAL MonthStart(Date), 2), Date)

effinty2112 — Mon, 07 Aug 2017 12:44:24 GMT

Hi Nitya,

Try this as in expression in a listbox:

=Aggr(only({$<Date ={">=$(=Monthstart(max(Date),-1))"}>}Month),Month)

Make a New Sheet Object \ List Box ...

In Field scroll right down and select <Expression> then enter the above.

Good luck

Andrew