Qlik Sense IF Else Statement Expression with Email mailto:

[Anonymous]

I have a table that has to have a email link in it from a IF Else statement. I can get the email to work fine but when I have the IF Else statement included, I get a invalid dimension. Any ideas on what I am doing wrong?

IF(45-(networkdays(max({<[Access Type]={'User Access', 'Login Access'}>} Date),Today())) = 15,


'mailto:'&EMAIL_ADDRESS&'?subject=Your QLIKSENSE Account has become DISABLED'&'&body= This is a NOTICE informing you that your Qlik Sense account has been disabled due to inactivity.

You will have 15 days to log into your account before the account is deleted.

All inactive accounts will be DELETED after 45 days of inactivity.

To access the Qlik Sense site, navigate to https://website and click Get Started.
')
,
IF(45-(networkdays(max({<[Access Type]={'User Access', 'Login Access'}>} Date),Today())) <= 5,

'mailto:'&EMAIL_ADDRESS&'?subject=Your QLIKSENSE Account has been deleted'&'&body= This is a NOTICE informing you that your Qlik Sense account has been deleted due to inactivity.

All inactive accounts will be DELETED after 45 days of inactivity.

To access the Qlik Sense site, navigate to https://website and click Get Started.
))

[andrey_krylov]

Hi, Patricia. Try this

IF(45-(networkdays(max({<[Access Type]={'User Access', 'Login Access'}>} Date),Today())) = 15,


'mailto:'&EMAIL_ADDRESS&'?subject=Your QLIKSENSE Account has become DISABLED'&'&body= This is a NOTICE informing you that your Qlik Sense account has been disabled due to inactivity.

You will have 15 days to log into your account before the account is deleted.

All inactive accounts will be DELETED after 45 days of inactivity.

To access the Qlik Sense site, navigate to https://website and click Get Started.
'
,
IF(45-(networkdays(max({<[Access Type]={'User Access', 'Login Access'}>} Date),Today())) <= 5,

'mailto:'&EMAIL_ADDRESS&'?subject=Your QLIKSENSE Account has been deleted'&'&body= This is a NOTICE informing you that your Qlik Sense account has been deleted due to inactivity.

All inactive accounts will be DELETED after 45 days of inactivity.

To access the Qlik Sense site, navigate to https://website and click Get Started.'
))

[Anonymous]

The expression indicates it's OK but when I click Apply, the table shows the dimension as a Invalid Dimension still.

[andrey_krylov]

OK, then it should work

IF(45-$(=networkdays(max({<[Access Type]={'User Access', 'Login Access'}>} Date),Today())) = 15,


'mailto:'&EMAIL_ADDRESS&'?subject=Your QLIKSENSE Account has become DISABLED'&'&body= This is a NOTICE informing you that your Qlik Sense account has been disabled due to inactivity.

You will have 15 days to log into your account before the account is deleted.

All inactive accounts will be DELETED after 45 days of inactivity.

To access the Qlik Sense site, navigate to https://website and click Get Started.
'
,
IF(45-$(=networkdays(max({<[Access Type]={'User Access', 'Login Access'}>} Date),Today())) <= 5,

'mailto:'&EMAIL_ADDRESS&'?subject=Your QLIKSENSE Account has been deleted'&'&body= This is a NOTICE informing you that your Qlik Sense account has been deleted due to inactivity.

All inactive accounts will be DELETED after 45 days of inactivity.

To access the Qlik Sense site, navigate to https://website and click Get Started.'
))