Where condition in direct discovery

[#1]

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 ?

[#2]

Hi Rohit

This document may be useful

QlikView 11 2 SR5 Direct Discovery Technical Addendum.pdf

regards

Darek

[ashfaq_haseeb]

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]

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