ValueList() Not working when using variable... help?

Thu, 14 Sep 2017 14:00:25 GMT

Hey, Qlik Community:

I'm trying to save sheet real estate by combining charts using the Variable extension and find that when using it in conjunction with ValueList(), I get the message 'The selections generated no data for this chart.' Here's the setup:

Variable extension with 2 values:

Variable name: vChartToggle

Value 1: 0

Value 2: 1

Target Visualization: Line Chart with 2 dimensions and one metric:

Dimension 1:

IF($(vChartToggle)=0, [YYYYMM],IF($(vChartToggle)=1,[MONTH_NAME]))

Dimension 2:

IF($(vChartToggle)=0,VALUELIST('Actual','Plan'),IF($(vChartToggle)=1,[YEAR_INT]))

Metric 1:

IF($(vChartToggle)=0,

PICK(MATCH(VALUELIST('Actual','Plan'),'Actual','Plan'),($(func_KPI('Actual','R13M'))),($(func_KPI('Plan','R13M')))),

IF($(vChartToggle)=1,SUM( {<

SCEN={'A'}

,[Reporting_mo_anchor.YYYYMM]={'$(_ReportingYearMonth2)'}

,[Reporting_mo.rte_code]={'YTD','YTDPY'}

>} Premium)))

It is important to note that when the variable is set to 1 (i.e. $(vChartToggle)=1) the chart works as expected. It's only when the chart value is set to 0 that it does not work. The charts also work if I separate them into two distinct charts without the use of a variable.

Anyone know any limitations on using ValueList() this way?

Re: ValueList() Not working when using variable... help?

shraddha_g — Fri, 15 Sep 2017 04:47:19 GMT

didn't find anything wrong with expression.

Can you share Sample app..

topic Re: ValueList() Not working when using variable... help? in App Development

ValueList() Not working when using variable... help?

Re: ValueList() Not working when using variable... help?