Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
Sgiri
New Contributor

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

Re: If condition

Hi

Try this 

Dimension = Year

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

Hope this helps

Thanks

Sgiri
New Contributor

Re: If condition

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

Partner
Partner

Re: If condition

Hi 

In which chart you should show these?

Can u more elaborate

Thanks

Re: If condition

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