Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

List of years to pass through variables dynamically

My concerns is  i have to pass all the years through varibles dynamically, in below i have hard coded years but tomrrow it will add the two More years like 2018 Or 2019 so that i have to  pass the years dynamically through variables. 

(RPT_YR = 2012 OR RPT_YR = 2013 OR RPT_YR = 2014 OR RPT_YR = 2015 OR RPT_YR = 2016 OR RPT_YR = 2017) AND
(COMP_DESC = 'COKY' OR COMP_DESC = 'MDP' OR COMP_DESC = 'MOCHA' )

I have set the two variables one for years and another for company list. but it is not working to see in the below script

 

(RPT_YR = $(Year) AND COMP_DESC = $(CompanyName))

Please let me if i am missing in the above expression or adding

10 Replies
bruno_m_santos
Partner - Creator
Partner - Creator

Do you want to ignore selections?

If so you can do like this:

Sum({<[RPT_YR]=,  COMP_DESC= >Value)