Discussion board where members can get started with QlikView.
I have two variables v_CurrentFiscalYear and v_CurrentFiscalYearPeriod. Those two are returing correct value is I use these to show only value in Text Object. But I want to show like this:
Fiscal Year = CurrentFiscalYear and Fiscal Month = CurrentFiscalYearPeriod
My expression is like this:
='Fiscal Year =' & ='$(v_CurrentFiscalYear)' & 'and Fiscal Month =' ='$(v_CurrentFiscalYearPeriod)'
But it is throwing error. How to to handle this.
Try removing the quotes around variable expansion and removing extra '=' signs, like:
='Fiscal Year =' & $(v_CurrentFiscalYear) & 'and Fiscal Month =' & $(v_CurrentFiscalYearPeriod)
View solution in original post
='Fiscal Year = ' & '$(v_CurrentFiscalYear)'
='Fiscal Year = ' & '$(v_CurrentFiscalYearPeriod)'