Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Where condition in direct discovery

hello ,

      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 ?

3 Replies
Not applicable
Author

Hi Rohit

This document may be useful

QlikView 11 2 SR5 Direct Discovery Technical Addendum.pdf

regards

Darek

ashfaq_haseeb
Champion III
Champion III

Hi,

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.

Regards

ASHFAQ

cristian_av
Creator III
Creator III

Just add a where in the load:

DIRECT QUERY

DIMENSION

...

MEASURE

...

DETAIL

...

FROM ...

LEFT JOIN ...

WHERE ...


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.

a.Field1=100 WRONG

Database.Table.Field1=100 CORRECT