topic Re: Dimensions Scripting in QlikView

Dimensions Scripting

powerqlik — Tue, 01 May 2018 16:43:48 GMT

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!

Re: Dimensions Scripting

sunny_talwar — Tue, 01 May 2018 16:48:48 GMT

May be like this

If(Year >= 2018, Year)

Re: Dimensions Scripting

adityaakshaya — Tue, 01 May 2018 16:52:34 GMT

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

Re: Dimensions Scripting

Chanty4u — Tue, 01 May 2018 16:54:37 GMT

may be try this too

Not tested

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

Re: Dimensions Scripting

powerqlik — Tue, 01 May 2018 17:52:22 GMT

Really appreciate you guys!