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.
Dear community -
I've a straight table like this -
Pid Pname Min Date Title PubDate
299 G Eq Qu 02-Apr-2018 G Eq Quart 25-Mar-19
Where Pid and Pname are dimensions and min date is an expression.
I've 2 other fields called title and Pub-date in another table and is not linked to either Pid or Pname.
The logic to calculate min date expression is - to wildmatch Pname with title, and if there's a match then pick the minimum PubDate associated to it.
Could anybody please help me in constructing such an expression.
many thanks in advance.
i attached an app as an example.
If you want to do the wildmatch pname should be the mask and title the string you are going to look into.
Hope it helps!
View solution in original post
Follow these steps:
Thanks for the prompt reply.
Sorry I wasn't very clear.
PName and Title can't be linked. infact Pname would be a substring of Title, hence I've to wildmatch and then pick the minimum published date corresponding to Title.
Hope that makes sense.
Thanks a lot. very helpful 😊