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 add where condition in direct discovery table ,how can i do that? i want to restrict my direct discovered table for 1 month value ?
This document may be useful
QlikView 11 2 SR5 Direct Discovery Technical Addendum.pdf
Make sure that you are using Qlikview 11.2 sr5 or grater.
Please find the attached document that will guide you how to achieve this.
Hope it helps.
Just add a where in the load:
LEFT JOIN ...
If you have an Where FieldA IN (1,2).. put it at last, because for some reason Qlikview just "cut" the SQL code after an IN.
Remember you need to use the full name of tables/fields, without Alias.