Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
and I will write is as
='October ' & num(max(CstFiscalYear)-1) & ' - ' & 'September' & max(CstFiscalYear)
try
='October ' & GetFieldSelections(CstFiscalYear) -1 & ' - ' & 'September' & GetFieldSelections(CstFiscalYear)
No sir,
It is missing first part. See below for year = 2015
Please help.
Thanks,
Sarif
and I will write is as
='October ' & num(max(CstFiscalYear)-1) & ' - ' & 'September' & max(CstFiscalYear)
Just remove the single colon for Qlikview functionalities and then use from your expression
='October ' & GetFieldSelections(CstFiscalYear) -1 & ' - ' & 'September' & GetFieldSelections(CstFiscalYear)