Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Sgiri
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
Kashyap_R
Partner - Specialist
Partner - Specialist

Hi

Try this 

Dimension = Year

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

Hope this helps

Thanks

Thanks and Regards
Kashyap.R
Sgiri
Contributor II
Contributor II
Author

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

Kashyap_R
Partner - Specialist
Partner - Specialist

Hi 

In which chart you should show these?

Can u more elaborate

Thanks

Thanks and Regards
Kashyap.R
Kushal_Chawda

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