Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
aghabdurauf
Contributor III
Contributor III

Restrict the month

Hi all,

I have 12 months Dates from 31-12-2020 to 30-11-2021

I use =monthName(addmonths(max(Date_Email), -1))

when I select 31-12-2020 it shows Nov-2020.

I want to restrict this however Nov 2020 is not in my data.

 

Thanks

Labels (2)
1 Reply
rubenmarin

Hi @aghabdurauf, and why is the addmonths function with -1, you can add an If to check the date before creating it, but if you don't create the date the fist month of data won't be related to any date.