Date Range in Text Box

[mhmmd_srf]

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

[annafuksa1]

try

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

[mhmmd_srf]

No sir,

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

Please help.

Thanks,

Sarif

[annafuksa1 · Accepted solution]

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)