Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Need to show only 3 Fiscal Years


I'm new to Qlikview so you'll have to bear with me on the technical side of things. I'm putting together a dashboard and for the Fiscal year calendar object I only want to show the years 2013-14, 2014-15 and 2015-16. At the moment the object is showing everything from 1899 till 2030. This is the object in question:

fiscal years.jpg

I am using a list box for the object with the field 'Calendar Year_Fiscal'. If you need any further info by all means let me know.

1 Solution

Accepted Solutions

Re: Need to show only 3 Fiscal Years

See if the attached screenshot and application helps

Capture.PNG

11 Replies

Re: Need to show only 3 Fiscal Years

May be use a list box expression:

If(Match([Fiscal Year], '2013-14', '2014-15', '2015-16'), [Fiscal Year])

anuradhaa
Contributor

Re: Need to show only 3 Fiscal Years

Can you please share a sample qvw

sasikanth
Valued Contributor III

Re: Need to show only 3 Fiscal Years

HI,

Please see attachment

Re: Need to show only 3 Fiscal Years

How you are creating fiscal Year in script?

Re: Need to show only 3 Fiscal Years

Good question. I agree it would greatly help if we know how the years getting loaded in. And also it might make sense to restrict the years in the script itself if those years are never going to be used in the application.

miguelbraga
Valued Contributor III

Re: Need to show only 3 Fiscal Years

Not applicable

Re: Need to show only 3 Fiscal Years

Hi and thanks for the prompt reply.

I tried that expression within the properties 'Expressions' tab, I changed the [Fiscal Year] to [Calendar Fiscal_Year] which is the field name in use. The displayed years must have turned into lots of characters because all it was showing in each column was '2.....' despite the columns being really wide. This is what I used:

(Match([Calendar Year_Fiscal], '2013-14', '2014-15', '2015-16'), [Calendar Year_Fiscal])

This is what it did to the object (I expanded the object better show the effect):

fiscal years 2.jpg

Not applicable

Re: Need to show only 3 Fiscal Years

Hello, how do I share a sample qvw? Will it contain confidential info because the data is very sensitive.

Re: Need to show only 3 Fiscal Years

See if the attached screenshot and application helps

Capture.PNG

Community Browser