Dimensions Scripting

[powerqlik]

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!

[sunny_talwar · Accepted solution]

May be like this

If(Year >=  2018, Year)

[adityaakshaya]

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]

may be try this too

Not tested

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

[powerqlik]

Really appreciate you guys!