Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a simple statement that I need help with.
If [date] field contains '2016', then display as '2016'
If [date] field contains '2017', then display as '2017'
If [date] field contains '2018', then display as '2018'
How do I properly write this up as one expression?
You can enter the following as a chart expression:
=if(OrderDate like '*2016*','2016',
if(OrderDate like '*2017*','2017',
if(OrderDate like '*2018*','2018','Other')))
View solution in original post
We can remove the nested If statements altogether ...
Try below ::