topic Re: Using direct query in Qlikview Personal Edition in QlikView

Using direct query in Qlikview Personal Edition

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 12 Apr 2017 10:44:17 GMT

hector_munoz — Wed, 12 Apr 2017 10:48:33 GMT

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,