Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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



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

Labels (1)
1 Reply
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:


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.



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.