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 have the following invalid expression and cannot understand why it is throwing error.
any experts who can perhaps point me in the right direction?
DATE(MAX(TILLTRADE_FOM))))) AS TEST
GROUP BY %Key
from the syntax side, you have a group by, so you need an aggr function
max(if(isNull(d), DATE((PREVIOUS(d))), DATE((d)))) AS TEST
don't know if it makes sense
View solution in original post
If possible could you attach a sample source for that script??
I guess you would like to get the following:
Group the data by %Key. For each group, get the max of field TILLTRADE_FOM and return it as a date. But in case all the data of a group only has NULLs in the field, get the max of the previous group.
If my assumption is correct you could do it as follows:
First, perform the group by and calculate the max(TILLTRADE_FOM) and create a new table with this.
In a second step, read in this table and check, where you got NULL as max and replace it by the result of the previous row (group of rows in your original data).
Otherwise: Could you describe what you would like to get? Could you provide sample data?