Discussion Board for collaboration related to Creating Analytics for QlikView.
I am trying to write an if statement in an expression using a YTD (Year to Date) field.
What I want to do is find out if the month "July" falls within the YTD field.
So something like.....If YTD contains July, then 1, else 0. I just don't know how to make the connection on a value that isn't actually part of the yield biut is associated with it.
Thanks in advance,
Are you asking to shift the YTD flag calculation from Jan to July Month ? or
If you already have [YTDField] in your table & we want check the YTDField in July month or not, then you can generaly IF statement like below:
IF( Month(YTDField)=7,1,0) AS YTDFlag
I have already identifed in the script which months are "YTD" and which months are "NOYTD". My issue is that I have an expression that I need to by able to identify specfic months in an if statement.
So I need to be able to write something along the lines of...
If YTD contains "July", then Expression 1, else expression 2
No because YTD is always changing. When next year comes July won't be associated with the YTD field until July comes. It needs to be dynamic.
I have 12 columns one for each month and each one needs to have this logic. THanks.