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: 
powerqlik
Contributor III
Contributor III

Dimensions Scripting

Hi Guys can someone help me with a scripting issue I am having in the Dimensions tab of a chart.  The chart is suppose to display the year a lease expires, the number of leases and the sqft for each year.

Everything is displaying just fine; however, sometimes the data the feeds the Dimensions script has outdated information for the YEAR.  (I.E 2015, 2016, 2017 data)  I only want the dimensions to show data => 2018.  For some reason, I can't get it to work.  Can someone assist?

Currently, the script for Dimensions just says  = Year   and it's showing all the right data; however, I want this modified to be something like = Year >= '2018'  ?

Thanks!

1 Solution

Accepted Solutions
sunny_talwar

May be like this

If(Year >=  2018, Year)

View solution in original post

4 Replies
sunny_talwar

May be like this

If(Year >=  2018, Year)

adityaakshaya
Creator III
Creator III

Hi Alen,

You can use Calculated Dimension. You can use below script. It will help you to get only >=2018.

if(Year>=2018,Year)

Let me know if you need more help on this.

Regards,

Akshaya

Chanty4u
MVP
MVP

may be try this too

Not tested

=if(YEAR>=max(total YEAR),YEAR)

powerqlik
Contributor III
Contributor III
Author

Really appreciate you guys!