Using direct query in Qlikview Personal Edition

[Anonymous]

Hi,

Is it posiible to work with direct query in Qlikview Personal Edition.

If it is possible, how do I have to change this script to do direct query?

ODBC CONNECT32 TO [odbc_access_qlickview;DBQ=C:\..................\Productos.mdb];

SQL  SELECT `cod_categoria`, `desc_categoria` FROM `Categoria_producto`;

When  I use direct query, data are selected from the source each time I ask for fields of the dataset?

Thanks in advance

[Anil_Babu_Samineni · Accepted solution]

Here you go What is QlikView Direct Discovery – Learn QlikView

[hector_munoz]

Hi Juan Vidal,

I think you can use Direct Discovery in Personal Edition. You created an ODBC connexion, that is correct but you have not the proper sentences:

• Instead of SQL SELECT use DIRECT QUERY
• You have to distinguish among dimensiones (DIMENSION), expressions (MEASURE) and details (DETAIL).

With Direct Discovery you only refresh MEASURE values...

I attach you a document.

Hope it serves!

Regards,

H