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 for collaboration related to QlikView App Development.
I need to count the record created during the year to year period regarding a date in different fields
To to so I created in the loading script a var :
SET vYearToYear = AddYears(Today(),-1);
In my table I have something like:
Finally I need to get in textboxes the number to [T-1] that hapened during the year to year period, the same for [T0] and so on.
I tried :
It give me 0 for [T-1] when it should be 7
What does this give you in a text box?
May be use dollar sign expansion
View solution in original post
May be try this:
Assuming T0 is formatted as DD/MM/YYYY
Could you pleas share that excel file ?
Thanks Sunny the date is formated DD/MM/YYYY but still have 0 as the answer
Here is the excel file
Due to the sign expansion Many Thanks Sunny