Scripting

RealEstate2018 — Sat, 16 Nov 2024 01:39:56 GMT

Hi,

I am trying to write a script that shows anytime there is a "Key Date Type" that references "Cancellation Option Notice End" then give me the "Key Date" for that respective Cancellation Option. Below is the script that I wrote which only half works...It shows None for every location irrespective if there is a Cancellation Option. Can someone please help modify?

if(count(distinct {<[Key Date Type] = {"Cancellation Option Notice End"}>} [Key Date Type])
,date(maxString(total <[Address Suite]> {<[Key Date Type] = {[Cancellation Option Notice End]}>} [Key Date]), 'MM/DD/YY')
,'None'
)

Re: Scripting

Brett_Bleess — Mon, 23 Dec 2019 20:42:40 GMT

You really need to attach a QVW file on posts like this, as folks need to be able to see the data model as well as your chart etc. in order to offer the correct potential solution... I am doubtful you will get a response otherwise.

The best I can do is point you to the Design Blog area, here is a key Set Analysis post that has some further post links at the bottom of it:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Here is the main URL to the Design Blog area in case you want to further search on your own, there are hundreds of posts in this area all from our internal experts and the vast majority are how-to related.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

topic Re: Scripting in QlikView

Scripting

Re: Scripting