Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a large nested if statement and would like to format it as follows:
if(Branch = 991, 'Export',
if(Branch = 322, 'Export non Group',
if(Channel = 5, 'Sample Account',
...
if(Channel = 9, 'Legacy', 'Potential'))))) as AccountType,
Is there a character I can place at the end of a line (such as after 'Export', ) that indicates that the command is continued on the next line?
The carriage returns are ignored by the expression editor so you are good from a functional standpoint.
Is it merely to document the expression for another developer ?
The carriage returns are ignored by the expression editor so you are good from a functional standpoint.
Is it merely to document the expression for another developer ?
your script already works in Qlik
Thank you both, I discovered the source of the error was an extra comma.
I'm re-scripting someone else's work who used VERY large nested if statements. I want to view the code like my example for my own understanding and hopefully find a better way of going about it.