Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Scripting

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'
)

Labels (1)
1 Reply
Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.