Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
powerqlik
New 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

Re: Dimensions Scripting

May be like this

If(Year >=  2018, Year)

View solution in original post

4 Replies

Re: Dimensions Scripting

May be like this

If(Year >=  2018, Year)

View solution in original post

adityaakshaya
Contributor III

Re: Dimensions Scripting

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
Esteemed Contributor III

Re: Dimensions Scripting

may be try this too

Not tested

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

powerqlik
New Contributor III

Re: Dimensions Scripting

Really appreciate you guys!