Discussion Board for collaboration related to QlikView App Development.
I have 2 variables vCurrentYear & vPreviousYear
vCurrentYear = right (year(today()),2)
because I only want it to get '14'
which will give me 13
Now, I want to create a new variable that will check a part of a field to see if its the current year or the previous year
I have a semester field which is filled like 1401, 1402, 1301, 1302
the 14 and 13 being the year.
now what I put into the variable was this
meaning count all the EMPLID where the first two digits of the semester field are equal to the Previous year which 13.
It won't work, I think it has to do with the syntax, some help please.
That's a tricky one. For now I found a small workaround modifying the vPreviousYear variable to 14*, 13* respectively.
13* in the set modifier does the same like using the left() function on the field (Which is not possible).
I must've missed it after trying to mix things up,
Eventually, written like this, I get a red line just under the bracket in bold.
Here's a link for another example of how to use this kind of search strings: