Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to create a field in Calendar with the 15 th and last day of month?

Hello,

how to create a field in the master calendar that contain the 15:th and last day of month? I need this

to be able to use it in Set Analyse with a counter or variable.

Håkan

1 Solution

Accepted Solutions
sbaldwin
Contributor III

Re: How to create a field in Calendar with the 15 th and last day of month?

Hi, try adding a field for your date field (called DateField) like

if(day(DateField)=15 or DateField = daystart(monthend(DateField)), 'Y','N') as Flag

Thanks

Steve

1 Reply
sbaldwin
Contributor III

Re: How to create a field in Calendar with the 15 th and last day of month?

Hi, try adding a field for your date field (called DateField) like

if(day(DateField)=15 or DateField = daystart(monthend(DateField)), 'Y','N') as Flag

Thanks

Steve

Community Browser