Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
cocuzzan
Partner - Contributor III
Partner - Contributor III

ValueList dimension if error

Hello,
i am implementing a dynamic chart in dimensions.
Based on your choice of current month or year to day (YTD), I dynamically change the size of the chart.

when i choose the YTD i would like the size to be the last 3 years.
otherwise I use the months of the last year
to do this I use the following code.

= if
(ThFilters.CMYTD = 'CM',
led2_month
,
ValueList (led2_anno-2, led2_anno-1, led2_anno)
)


The editor doesn't give me any problems. gives me the OK.
The problem though is that the graph gives me the wrong size.

The problem is that the chart does not recognize the use of the ValueList when inside IF.

If I use only ValueList instead I have no problem.

Where am I wrong?

 

 

 

Cattura.JPG

Cattura2.JPG

  

target.JPG

 

 

 

2 Replies
Gabriel
Partner - Specialist III
Partner - Specialist III

May be try PICK MATCH function

cocuzzan
Partner - Contributor III
Partner - Contributor III
Author

?