topic Re: alternate state issue in QlikView

alternate state issue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

i am facing problem with alternate state.

My requirement is to show 3 years of data in line chart with separate year filter.

So i have create one variable for year like

var_YEAR=IF(ISNULL(GetFieldSelection(YEAR,'','')),MAX(YEAR),(GetFieldSelection(YEAR,'',''))-2 (It show 3 years of data at a time)

Set Expression SUM({<KPI={'Production'},YEAR={">=$(=var_YEAR)<=$(=var_maxYear)"})

till this it showing 3 years data in chart, but when i used alternate state 'chart1 ' in set expression then its showing all years of data at a time.

i tried below variable but still same issue

var_YEAR=IF(ISNULL(GetFieldSelection(YEAR,'','','Chart1')),MAX(YEAR),(GetFieldSelection(YEAR,'','','Chart1'))-2 (It show 3 years of data at a time)

Please help me to find out.

Thanks

jwjackso — Mon, 05 Mar 2018 12:39:24 GMT

GetFieldSelections does not work with alternate states. See an example of using the concat function in the URL below:

Anonymous — Mon, 05 Mar 2018 13:00:22 GMT

But Below variable is working

var_YEAR=IF(ISNULL(GetFieldSelection(YEAR,'','','Chart1')),MAX(YEAR),(GetFieldSelection(YEAR,'','','Chart1'))-2