Discussion board where members can get started with Qlik Sense.
I am trying to find out following.
if End date is not null, then end date - start date+1 else today-start date. While doing so, i am getting error in expression error. Would anyone help me to resolve ?
=if((not isnull[End_date],[End_date]-[Start_date]+1), today()-[Start_date])
=if(not isnull([End_date]),([End_date]-date([Start_date],1)), today()-[Start_date])
You can simplify the expression like this:
=Alt([End_date] + 1, Today()) - [Start_date]