topic Re: List box in QlikView

List box

manoranjan_d — Mon, 11 Jul 2016 12:28:29 GMT

in my list box there is lot of year

example 2012 to 2016

now in my list i need the current year and previous year only

how we can achieve it?

and then coming to the chart

dimension which have

if(date#(date(DT,'YYYY'))=Year(today()),date#(date(DT,'MMM')))

expression have count and amt

according to the year selection in list box it shd show the all the months available to the year

how can we achieve it?

Re: List box

Peter_Cammaert — Mon, 11 Jul 2016 12:31:27 GMT

The years may be ok but the base date from which the year is lifted probably still contains the full date. When creating the Year field, use somthing like Year(YearStart(Date)) and you'll only get one of each in your listbox.

Best,

Peter

Re: List box

sunny_talwar — Mon, 11 Jul 2016 12:33:00 GMT

May be for list box try this:

If(Year >= Year(Today()) - 1, Year)

In your chart you just need Max year's month? May be this:

MonthYear(DT)

Add this to your expression:

{<DT = {"$(='>=' & Date(YearStart(Max(DT)), 'DateFieldFormatHere') & '<=' & Date(Max(DT), 'DateFieldFormatHere'))"}>}

Re: List box

manoranjan_d — Tue, 12 Jul 2016 10:33:05 GMT

No in my chart if the user select the 2015 year then it should show months available to the 2015 or 2016 means it should show according month for 2016 available