Hi,
I am new to Qlik view and have the following question.
I am importing a Excel spreadsheet which has a Description field. In the select statement i am currently using nested IF() statement with the LIKE *Sample* to generate a new field with a group description for example
Description = 'this is January 2015'
,IF(Description like *Jan*,'blue','black') AS Group
Now Qlik has a limit of upto 100 nested IF statements.
Is there a way for me to store the keywords in a table(populated from another spreadsheet) and "Join" onto my main import table ? the trick is that i must still use the LIKE operator or something similar in order to identify each record and assign it to the group from my template.
I hope this makes sense.
thanks