Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

See if the attached screenshot and application helps

Capture.PNG

View solution in original post

11 Replies
sunny_talwar

May be use a list box expression:

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

anuradhaa
Partner - Creator II
Partner - Creator II

Can you please share a sample qvw

sasikanth
Master
Master

HI,

Please see attachment

Kushal_Chawda

How you are creating fiscal Year in script?

sunny_talwar

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
Partner - Specialist III
Partner - Specialist III

Not applicable
Author

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
Author

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

sunny_talwar

See if the attached screenshot and application helps

Capture.PNG