Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
mhmmd_srf
Creator II
Creator II

Date Range in Text Box

Hi All,

My requirement is if user select 2017 from Fiscal Year, then it should show October 2016 - September 2017.

Similarly if user select 2016, the October 2016 - September 2016.

My expression like below:

='October ' & 'GetFieldSelections(CstFiscalYear) -1' & ' - ' & 'September' & 'GetFieldSelections(CstFiscalYear)'

It is not working.

Could you please help me on this.

Thanks,

Sarif

1 Solution

Accepted Solutions
annafuksa1
Creator III
Creator III

and I will write is as

='October ' & num(max(CstFiscalYear)-1)  & ' - ' & 'September' & max(CstFiscalYear)

View solution in original post

4 Replies
annafuksa1
Creator III
Creator III

try

='October ' & GetFieldSelections(CstFiscalYear) -1 & ' - ' & 'September' & GetFieldSelections(CstFiscalYear)

mhmmd_srf
Creator II
Creator II
Author

No sir,

It is missing first part. See below for year = 2015

Please help.

Thanks,

Sarif

annafuksa1
Creator III
Creator III

and I will write is as

='October ' & num(max(CstFiscalYear)-1)  & ' - ' & 'September' & max(CstFiscalYear)

Anil_Babu_Samineni

Just remove the single colon for Qlikview functionalities and then use from your expression

='October ' & GetFieldSelections(CstFiscalYear) -1 & ' - ' & 'September' & GetFieldSelections(CstFiscalYear)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful