I am currently using Qlik Sense Desktop June 2018, I need to create a flexible URL link and label depending on what data is available in my straight table. The link will either open up a link which would be a concatenation of the URL link the ID field or open outlook for draft email.
What I am stuck at right now is getting the label to display the correct name by using an IF statement. It works when it is simply just a string e.g. 'Link'. But, once I use an expression for the label, the table breaks and shows nothing or it says it's out of memory.
My expression for the label:
=IF([Report Date]=(vReportDate),
IF(LEN([ID])>1,
IF([Status]='Active', [ID], 'Create Mail'
)))
