topic Re: Fiscal Month Year Displaying in List Box in QlikView

Fiscal Month Year Displaying in List Box

sudhir0538 — Thu, 02 Nov 2017 04:34:23 GMT

Hello Techies! Morning greetings.

I have a list box with month year values from database table. Instead of all the items I want to display only the financial period for the selected year.

if user select 2017 the list box (which contains month and year) should display from Apr-2017 to Mar-2018(if available else upto current month) instead of from Jan-2017 to current month.

Please help to achieve this.

Image 1: Normally displaying like this

Image 2: Desired Outcome if 2017 year selected

Re: Fiscal Month Year Displaying in List Box

tresB — Thu, 02 Nov 2017 04:41:26 GMT

Create FiscalYear field in the script, like:

Year(YearStart(DateField,0,4)) as FiscalYear

Re: Fiscal Month Year Displaying in List Box

sudhir0538 — Thu, 02 Nov 2017 05:11:03 GMT

Hai Treseso , This solution works fine. Thnx for the help.

How can i achieve the same if there's no provision for user to select the year. Like in the chart i want to display only the current fiscal year data.

like in this above pivot table i want to display on the current fiscal year data without selecting the fiscal year from fiscal_year list box.

Re: Fiscal Month Year Displaying in List Box

tresB — Thu, 02 Nov 2017 05:15:06 GMT

You can use set analysis in aggregation function you use as expression.

Sum({<FiscalYear={'$(=Max(FiscalYear))'}>} Sales)

Re: Fiscal Month Year Displaying in List Box

sudhir0538 — Thu, 02 Nov 2017 05:28:51 GMT

great bro,it's working!!