1 Reply Latest reply: Sep 15, 2017 12:47 AM by Shraddha Gajare RSS

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

    Denis Gauthier

      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?