Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

If condition

Hello All, 

 

     I have a field name called Year_number and it has values like 2020,2019,2018 goes on till 1980

 

I created a variable called vYear and added value as 1 so in the chart when I enter 1 I should get 2020 then when I enter 2 then I should 2019 and 2020 and when I enter 3 then I should get 2018, 2019 and 2020. I wanted to change it dynamically

 

 

Thanks

4 Replies
Partner
Partner

Hi

Try this 

Dimension = Year

Measure = Sum({<[Year] = {"=vRank(max(Year]))<=$(Variable)"}>}[Value])

Hope this helps

Thanks

Contributor II
Contributor II

I wanted to show that on dimension I have no measure to show.

Partner
Partner

Hi 

In which chart you should show these?

Can u more elaborate

Thanks

MVP
MVP

"When I enter" where you are entering? What you are entering?