This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
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 ::